UserForm
 

hi
i think your have loaded your form as modal meaning that no other actions
can be perform until the form is closed. if you want the form to remain open
plus do other things on the sheet, you must load the form modeless.

UserForm.show 0

1= modal(default)
0= modeless.

look up the show method in vb help for more info.

Regards
FSt1

"bgkgmg" wrote:

I've put some contol boxes in a UserForm in VBA of Excel sheet. I'm having a
difficult time transferring the UserForm to my Excel worksheet. The only way
it appears on sheet is when I type "UserForm.show" but will not allow me to
use anything else.

Thanks
Bobby