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() vbModeless
End Sub

1 comment:

  1. My modeless userforms are freezing my computer either via 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?