Command Button

[How_Do_I]

I enter my data via a User Form. I've noted that when I press my command button to enter my data, if I press it again while my cursor is spinning and "thinking" about entering the correct data, then the next set of data can be entered. How can I prevent this please?

 

[How_Do_I]

Yes, but what if somebody else uses this and presses away... I know not to keep pressing but I was hoping for a bit of VBA code as a fail safe.

 

[Ruddles]

If you disable the button as soon as it's clicked and only re-enable it again when you're actually ready for it to be clicked again, that can't happen.

Private Sub CommandButton3_Click()
Dim ws As Worksheet
Dim MyForm As UserForm1
CommandButton3.Enabled = False
'
' rest of code 
'
CommandButton3.Enabled = True
End Sub

(Why couldn't Man U have played like that on Tuesday?!)