VBA for color index 192

**shiva_reshs** · 10-30-2013, 10:52 AM

Hi,

128 is VBA color index code for dark red. I know Index 9, but 192 is slight different red.

How can I fit that into below VBA?

Please Login or Register  to view this content.

When I change to 192, I get below error msg

Run-Time error '9':
Subscript out of Range.

Regards,

**nilem** · 10-30-2013, 11:00 AM

maybe ....Interior.Color = 192

**shiva_reshs** · 10-30-2013, 11:05 AM

nice..

and how to add or make font color changes to white in the same cell??

Regards,

**Andy Pope** · 10-30-2013, 11:07 AM

128 is RGB code for a shade of Red

Please Login or Register  to view this content.

ColorIndex values are 0 to 57 are maps to the old colour pallete in xl2003.

**shiva_reshs** · 10-30-2013, 11:08 AM

oh.. got it

Thanks!!

**nilem** · 10-30-2013, 11:08 AM

.....Font.Color = vbWhite

**shiva_reshs** · 10-30-2013, 11:09 AM

Thanks a ton..

Reps added.
Regards

**JOHN H. DAVIS** · 10-30-2013, 11:20 AM

You can use the index for the font.

Please Login or Register  to view this content.

**shiva_reshs** · 10-30-2013, 11:47 AM

Thanks John!

Regards,

Re: VBA for color index 192