Microsoft Excel Question:
Download Job Interview Questions and Answers PDF
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?
Answer:
Use a line of code like this:
OrigColor = Selection.Interior.ColorIndex
OrigColor = Selection.Interior.ColorIndex
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can I see a list of the ColorIndex and the corresponding color? | How can I make the screen stop flashing during macro execution? |