Double click the button you created on the userform and paste this

If CheckBox1.Value = False Then
MsgBox "Check The Checkbox", vbCritical
Exit Sub
End If
MsgBox "replace me with code"

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Hazel" wrote:

Hi All

I have a userform with several Commandbuttons there is one button that I
would like to control by a Checkbox -- in other words the user would have to
click the Check Box before the Command Button would work - and if the user
clicked on the Command Button 1st a message box would ask the user to click
the Check Box before the Command button will work. For all you experts out
there is that possible??
--
Many thanks

hazel

Gentlemen --- Thank you -- either of the codes, both worked brilliantly

Happy New Year
--
Many thanks

hazel


"John Bundy" wrote:

Double click the button you created on the userform and paste this

If CheckBox1.Value = False Then
MsgBox "Check The Checkbox", vbCritical
Exit Sub
End If
MsgBox "replace me with code"

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Hazel" wrote:

Hi All

I have a userform with several Commandbuttons there is one button that I
would like to control by a Checkbox -- in other words the user would have to
click the Check Box before the Command Button would work - and if the user
clicked on the Command Button 1st a message box would ask the user to click
the Check Box before the Command button will work. For all you experts out
there is that possible??
--
Many thanks

hazel