Sunday, May 13, 2007

Modeless Forms


Sometimes you want to allow users to be able to switch between your form and your spreadsheet by clicking on either one. All you need to do is set the form property of Show Modal to False or you can try this. However this is only for Excel 2000 & above.

Sub myForm()
UserForm.show vbModeless
End Sub

Posted by Ayush Jain at 7:44 AM

1 comment:

  1. Marcelo DreuxMarch 14, 2008 at 1:35 PM

    My modeless userforms are freezing my computer either via UserForm.show vbModeless or via the ShowModal Property set to False. I have to kill the Excel process.

    What could be wrong? I am using a Excel 2003 running on Windows XP version 2002 Service Pack 2.

    Any hints?

    ReplyDelete

Subscribe to: Post Comments (Atom)