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

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

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

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

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

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

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

interior color of a cell
 

Leith, imported the BAS file and the FRM file. What do I do with the
FRX file? TIA

Greg

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

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