I have a userfirm with 15 checkboxes on it. I would like to call this
userform from an option off of a menu item I have added to the main
menubar.
When the form is called from the menu, I can't click on the
checkboxes. More precisely, clicking on the blank checkboxes has no
effect on them.
However, when I go into the
VB editor and, by pressing F5, run the
same macro that's called by the menu item, I can mark the checkboxes,
and everything runs fine.
The code I'm trying to run in the first case and am successfully
running in the second is simple:
Sub ShowForm()
UserForm1.Show
End Sub
Any ideas on what's wrong and how to fix it?
TIA.