User form Command Buttons
Thank you worked great.
"Jim Thomlinson" wrote:
By toggling the enabled property of the command buttons you can control the
flow. Something like this. buttons 2 and 3 are disabled at start up. When
button 1 is pressed button 2 is enabled. When button 2 is pressed button 3 is
enabled.
Private Sub CommandButton1_Click()
CommandButton2.Enabled = True
End Sub
Private Sub CommandButton2_Click()
CommandButton3.Enabled = True
End Sub
Private Sub UserForm_Initialize()
CommandButton1.Enabled = True
CommandButton2.Enabled = False
CommandButton3.Enabled = False
End Sub
--
HTH...
Jim Thomlinson
"jhyatt" wrote:
Does anybody now how to code a button in a user form to not work until the
other buttons are clicked. for example i have 3 buttons one "OK" one "next"
one "close". I would like the user to click the ok button then the next,
then the close when theu are done. any help would be appreciated.
Thank you
J
|