Disable form button after macro is finished (1 Viewer)

scubadiver007 · Feb 29, 2012

Hello folks,

Once I have made a selection from a drop-down and hit the button, I then want the button to be disabled once the macro is finished

Thanks

NickHa · Feb 29, 2012

In the click event of your button, you can disable the drop-down box:

Code:

Private Sub CommandButton_Click
Me.ComboBox.Enabled = False
End Sub

You will have to re-enable the combo box at some point. The Form's Current event could be used for this:

Code:

Private Sub Form_Current
Me.ComboBox.Enabled = True
End Sub

Disable form button after macro is finished (1 Viewer)

scubadiver007

Registered User.

NickHa

CITP

Similar threads

Users who are viewing this thread