Button Color

[Drmwvr7266]

I have a userform that I created. Is there a way to change the color once the button has been clicked?

I'm sure if I had a checkbox, which has true and false, I could change from one color to another depending on the status of checked or not.

However, with the command button, I'm not sure. If I clicked it once, it would most likely stay the new color.

Example:

Commandbutton1 'Standard gray

Commandbutton_click
'changes to blue.

This way, the user would know if that function had been performed.

G

 

[Tom@CPC]

Try this

Private Sub CommandButton1_Click()
CommandButton1.BackColor = &HFF8080
End Sub

HTH,
Regards, Tom

 

[lenze]

Depending on your application, it might also be possible for you to use a ToggleButton instead of a Command button. The ToggleButton has a Value property of TRUE FALSE