View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DFStoneJr DFStoneJr is offline
external usenet poster
 
Posts: 2
Default Can't check checkboxes in userform ... sometimes

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.