Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

In visual basic, I can set the color of a cell with the .interior.colorIndex property. How can I read the color of a cell before I change it?

April 26, 2017CELL color Property read visual basic

0

Posted

In visual basic, I can set the color of a cell with the .interior.colorIndex property. How can I read the color of a cell before I change it?

1 Answer

0

Posted

Use a line of code like this: OrigColor = Selection.Interior.ColorIndex Can I see a list of the ColorIndex and the corresponding color To see the colors, go to the visual basic editor. Hit the help question mark. Type ColorIndex. From the list of topics, select the one called “ColorIndex Property”. They have a nice visual table at the bottom of this help topic.