Browse by Tags

Change Color of Listbox row w/ VBA

I don't think this is possible: Can I change the color of a single row in a listbox or maybe even the text of a single column in a single row based on the value of a particular field?

Posted to Access (Forum) by microsoft on 03-21-2010
How do i use in VBA custom color code? Is it limited to the 40 excel 2003 colors palette?

Dear experts, How do i use in VBA custom color code? Is it limited to the 40 excel 2003 colors palette? I tried to use RGB() or to copy color code from Access, but I got an Overflow error. Thanks in advance

Posted to Excel (Forum) by microsoft on 09-11-2009
change color of line on chart VBA

How do I change the color of a line on a chart with VBA?

Posted to Excel (Forum) by microsoft on 08-14-2009
Worksheet Tab Color - Programmatically Changing the Color - How To?

Is it possible to set the worksheet's tab color conditionally based upon the value of cells or the result of a function? If it cannot be done this easily, is it possible, using VBA, to use the Tab property of the Worksheet object to set the Color property of the Tab object? Any and all help would...

Posted to Excel (Forum) by microsoft on 07-28-2009
Automate chart color and data to Excel with VBA for Specific Cell

I have a created an excel template that is filled with VB code from access 2003. I have a chart that is coded with a specific "Case" for 5 cells in that excel template. They all have the same criteria, but I have one cell in that group that has a different criteria. How can I change that cell's...

Posted to Access Coding/Macros (Forum) by microsoft on 07-13-2009
Access vba/Word change line color in header/footer

Access vba creating word report. I have a line in the header & footer of a doc report that I would like to change the color of depending on the data being added to the report. I don't know how to reference the line.

Posted to Access (Forum) by microsoft on 07-01-2009
VBA - Change cell color

How do I implement the following logic in VBA: If Cell A1 >= Cell A2 Then Change Color Of Cell A1 To Red Change Color Of Cell A1 To Red End If - I want this triggered by numbers being entered in either Cell A1 or Cell A2 - I need to test for this condition for a range of cells (i.e. Cell A1-A20) ...

Posted to Excel (Forum) by microsoft on 06-19-2009
Problem: Excel VBA: how to identify calling cell reference and set fill color within a function?

I would like to be able to set a cell fill based on some data quality identifiers pulled with a value from an ODBC database. The DB stuff is done and working, but setting a fill color is giving me trouble; I appear to be able to set cell color only within a worksheet_change event or in code triggered...

Posted to Excel (Forum) by microsoft on 06-01-2009
Problem: Shades of Gray Color Index vba

Although I have used the code (see below) posted as an answer by byundt in a previous question on interior cell colors, I need to take it further by getting the numbers for all of the shades of Gray between 10% and 100% plus any other colors that may be available over the 56 given by Brads code : Sub...

Posted to Excel (Forum) by microsoft on 06-01-2009
Problem: Format Cell Color using VBA

I have an action list with the following columns: A B C D E 1 Number Desc. Who? When Due? 2 3 The Workbook is shared so I can not use conditional formatting. I would like the entire row's cell background color to turn red if the Due Date has passed. I understand that I can do it with VBA, please...

Posted to Microsoft Office (Forum) by microsoft on 05-31-2009

Page 1 of 2 (12 items) 1 2 Next >