Check Box Question
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
|