I have two questions:
1. How do I identify a fill color for a cell so that I can match the text
to the color to hide it? Is there a beter way to hide the text so that it is
not visble?
2. A lot of times when I ask for help on a code, you use 'Me'. For example
'Me.commandbutton2.enabled = ok'. What is Me? I don't use it and it seems
to work fine.
Thanks
pswanie - 17 Mar 2008 21:00 GMT
1. How do I identify a fill color for a cell so that I can match the text
to the color to hide it? Is there a beter way to hide the text so that it
is
not visble?
record a macro while changing the color of the cell. it will then show the
number in the editor
2. A lot of times when I ask for help on a code, you use 'Me'. For example
'Me.commandbutton2.enabled = ok'. What is Me? I don't use it and it seems
to work fine.
the me points to the specific userform where the commandbutton2 is located.
could use userform1.commandbutton2.enabled = ok
pswanie - 17 Mar 2008 21:21 GMT
something like this
Sub Macro1()
With Selection.Interior
.ColorIndex = 6
'yellow collor
.Pattern = xlSolid
Selection.Font.ColorIndex = 6
End With
End Sub
**********************************************************