Heyjoe
New member
I took a cell on a worksheet and changed the background color. I recorded a macro while I did this. You see in the macro that the cell background color is 10092543.
Sub Macro2()
'
' Macro2 Macro
'
'
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 10092543
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
The back color on my command button is &H00C0FFFF&.
How do I get the backcolor on the cell and the command button to be the same?
Sub Macro2()
'
' Macro2 Macro
'
'
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 10092543
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
The back color on my command button is &H00C0FFFF&.
How do I get the backcolor on the cell and the command button to be the same?