473,396 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

VBNET2008 Set Excel 2003 specific Row BackGround color to Yellow

126 100+
Hullo Good Friends,
I am using VBNET2008 and Excel 2003.
I need your help. Please help me.

I am trying to develop coding to specific set the Excel 2003 Row BackGround Color to Yellow and it's not working as I have not done it before logically.

Here is the coding that is not working:
Expand|Select|Wrap|Line Numbers
  1. xlWrkSheet.Rows(intRow).BackGroud.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow)  
Here are part of the overall Coding:
Expand|Select|Wrap|Line Numbers
  1. Dim xlExcel As Excel.Application
  2. Dim xlWrkBook As Excel.Workbook
  3. Dim xlWrkSheet As Excel.Worksheet
  4. Dim xlRange As Excel.Range
  5. Dim oMissing As Object = System.Reflection.Missing.Value
  6.  
  7. Dim intRow as interger = 5
  8. xlWrkSheet.Rows(intRow).BackGroud.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow) 
  •  
  • Please help me with sample working coding. I will learn new logical technic from it.

    Thank You,

    Cheers,
    Lennie
    Jan 17 '11 #1
    0 1038

    Sign in to post your reply or Sign up for a free account.

    Similar topics

    25
    by: Neal | last post by:
    According to the CSS lint at http://htmlhelp.org/tools/csscheck/, "The shorthand background property is more widely supported than background-color." Can anyone point me to, or provide, information...
    13
    by: Gary | last post by:
    I have a table with a form consisting of several checkboxes and I'm wondering if its possible to change the table row background color on mouseover or hover and make it stay that color when the...
    3
    by: Roberto Castro | last post by:
    Hello! I have been assigned for the first time an adp Access project and so far I have managed to make the changes needed for some requirements. However, I am struggling to find the place where...
    2
    by: iforsyth | last post by:
    I'm doing a query against a database table and outputting to Excel via Response.ContentEncoding and Response.ContentType. Something like the code below where dg is a DataGrid control. ...
    0
    by: Tom | last post by:
    Hi I have a ListBox control of my asp.net web page. I want to set the value of the style property of the ListItem to a specific background color. I have tried this but no success: //li is...
    5
    by: DavidB | last post by:
    Greetings I don't know if this is possible, but this group should be able to tell me. I have a webpage with a changing message board (I understand the problems with having changing text, but...
    1
    by: ngpost1 | last post by:
    I have a Crystal Reports.Net report being generated from my C# application. I would like to change the background color of the details section (not the text mind you) of the report on certain...
    3
    by: shapper | last post by:
    Hello, Could someone, please, tell me how to change the background color of div when the mouse is hover it? Thanks, Miguel
    2
    by: bsrcss | last post by:
    I added a 3 column lists to my site using the techniques shown on http://www.communitymx.com/content/article.cfm?page=1&cid=27F87 I first tried their code by itself and it worked fine. When I...
    3
    Frinavale
    by: Frinavale | last post by:
    Hi there, I'm using JavaScript to highlight a row or column in a table. I have created a CSS class that changes the background colour to a light blue and I apply this class to the cells in the...
    0
    by: Charles Arthur | last post by:
    How do i turn on java script on a villaon, callus and itel keypad mobile phone
    0
    by: ryjfgjl | last post by:
    In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
    0
    by: emmanuelkatto | last post by:
    Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
    0
    BarryA
    by: BarryA | last post by:
    What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
    0
    by: Hystou | last post by:
    There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
    0
    by: Hystou | last post by:
    Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
    0
    Oralloy
    by: Oralloy | last post by:
    Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
    0
    tracyyun
    by: tracyyun | last post by:
    Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
    0
    agi2029
    by: agi2029 | last post by:
    Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

    By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

    To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.