| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
interior color of a cell
I searched in googles groups search I could not get satisfactory answer.
in the inermediate window if I type activecell.inteiro.colorindex=3 the cell turns red (i.e filled with red color) in the same window if I type ?activecell.interior.colorindex it gives result as 46 In a sub If I use a statement if activecell.interior.colorindex=3 then ------------- it does not receognise that the cell color is red But if I type if activecell.interior.colorindex=46 then ------- it works. clarifications sought. thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Hi,
Colorindex=3 is RED, colorindex=46 is ORANGE (but they look very similar) so it will be worthchecking the activecell is really what you think it is.. I did your tests and found no problem. "R.VENKATARAMAN" wrote: I searched in googles groups search I could not get satisfactory answer. in the inermediate window if I type activecell.inteiro.colorindex=3 the cell turns red (i.e filled with red color) in the same window if I type ?activecell.interior.colorindex it gives result as 46 In a sub If I use a statement if activecell.interior.colorindex=3 then ------------- it does not receognise that the cell color is red But if I type if activecell.interior.colorindex=46 then ------- it works. clarifications sought. thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Hello R.VENKATARAMAN, Toppers' post makes a good point. Sometimes it is difficult to tell the difference between colors when you are shifting from one then to the other. I created a VBA form that will display both the ColorIndex number and the Color on individual buttons. If you can't read a button because of the color, click it and you will see the number. This helps in picking the right color you want to use. Download the attached file, UnZip it, and import the User Form and macro Module into your program using the VBA editor. Sincerely. Leith Ross +-------------------------------------------------------------------+ |Filename: Show_Color_Index_Chart.zip | |Download: http://www.excelforum.com/attachment.php?postid=4026 | +-------------------------------------------------------------------+ -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483839 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Since R. VENKATARAMAN is not posting in the Excel Forum, he will not be able
to access your attachment. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello R.VENKATARAMAN, Toppers' post makes a good point. Sometimes it is difficult to tell the difference between colors when you are shifting from one then to the other. I created a VBA form that will display both the ColorIndex number and the Color on individual buttons. If you can't read a button because of the color, click it and you will see the number. This helps in picking the right color you want to use. Download the attached file, UnZip it, and import the User Form and macro Module into your program using the VBA editor. Sincerely. Leith Ross +-------------------------------------------------------------------+ |Filename: Show_Color_Index_Chart.zip | |Download: http://www.excelforum.com/attachment.php?postid=4026 | +-------------------------------------------------------------------+ -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483839 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Hi Tom, I wasn't aware of that, thanks. Where could I post it so the OP coul download the file? Thanks for your help, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=48383 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Well, he could use the thread link at the bottom to go to the Excel forum,
then he can access the attachment from your posting in the Excel forum. Guess I should have said that in the original post - sorry. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hi Tom, I wasn't aware of that, thanks. Where could I post it so the OP could download the file? Thanks for your help, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483839 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Venka must be having my problem of failing to distinguish between som fine shades of color (light green/light yellow in my case). Coming to that, some of us are not much favored by the overly ornat decor used in EXCEL 2003. I'd rather the old grey in earlier version of EXCEL. Davi -- david ----------------------------------------------------------------------- davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064 View this thread: http://www.excelforum.com/showthread.php?threadid=48383 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
Leith, imported the BAS file and the FRM file. What do I do with the
FRX file? TIA Greg |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
understood . I think I am a subscriber to excel forum also. shall try
there. "Tom Ogilvy" wrote in message ... Since R. VENKATARAMAN is not posting in the Excel Forum, he will not be able to access your attachment. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello R.VENKATARAMAN, Toppers' post makes a good point. Sometimes it is difficult to tell the difference between colors when you are shifting from one then to the other. I created a VBA form that will display both the ColorIndex number and the Color on individual buttons. If you can't read a button because of the color, click it and you will see the number. This helps in picking the right color you want to use. Download the attached file, UnZip it, and import the User Form and macro Module into your program using the VBA editor. Sincerely. Leith Ross +-------------------------------------------------------------------+ |Filename: Show_Color_Index_Chart.zip | |Download: http://www.excelforum.com/attachment.php?postid=4026 | +-------------------------------------------------------------------+ -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483839 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
interior color of a cell
thank you. It is a pleasure and educative to participate in newsgroups like
this "Tom Ogilvy" wrote in message ... Well, he could use the thread link at the bottom to go to the Excel forum, then he can access the attachment from your posting in the Excel forum. Guess I should have said that in the original post - sorry. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hi Tom, I wasn't aware of that, thanks. Where could I post it so the OP could download the file? Thanks for your help, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=483839 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to set cell interior color? | Excel Discussion (Misc queries) | |||
| Cell interior color | Excel Discussion (Misc queries) | |||
| Problem in setting Cell Interior Color filling. | Excel Programming | |||
| Interior Cell color | Excel Programming | |||
Linear Mode
