How can I changing a VBA command button color w/out re-opening form?

[PicketOaks]

Hi -

I would like to know how to refresh a form after using a command button. That is, I created a command button that evokes a comment box. After I enter in a comment I would like to change the color of the button right away. For now, I need to close the form and reopen it for color change to show.

Any help here is greatly appreciated. Please note I'm not a professional programmer (yet) so will need a somewhat explict example.

Thanks in advance!

 

[mintjulep]

Private Sub CommandButton1_Click()
CommandButton1.BackColor = RGB(1, 1, 200)
End Sub

 

[Andrzejek]

or:

Option Explicit

Private Sub CommandButton1_Click()
CommandButton1.BackColor = vbButtonFace
End Sub

Private Sub UserForm_Click()
CommandButton1.BackColor = vbYellow
End Sub

Have fun.

---- Andy

 

[PicketOaks]

Thanks all... got it working now.