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.

Bump. Anyone have any ideas?


"DFStoneJr" wrote in message
m...
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.