Could you possibly explain me or show some part of code:
How can I get active cell color form Excell sheet.
Thanks in advance
Printable View
Could you possibly explain me or show some part of code:
How can I get active cell color form Excell sheet.
Thanks in advance
I think its selection.interior.color
Easiest way is to record a new macro in excel, change the colour of the cell, stop recording and view the code. It should tell you how to get the number for the colour.
Vince
Ecniv is spot on, it's :
VB Code:
Private Sub CommandButton1_Click() MsgBox Cells(1, 1).Interior.Color End Sub