Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Modal Userforms? Non Modal Userforms?

Posted by Ron on June 22, 2001 11:31 AM
I have an Excel workbook with many userforms I've created. Is there a way to allow the user to open and use other workbooks while a user form is open? Currently, when they go to another workbook the userform stays on top and doesn't allow the user to enter information on the other workbook.

Ideas or suggestion?? Thanks.


Re: Modal Userforms? Non Modal Userforms?

Posted by Damon Ostrander on June 22, 2001 12:20 PM
Ron,

Modal userforms are not available in versions of Excel prior to 2000. In 2000 and beyond, set the ShowModal property of the UserForm to True.

Happy computing.

Damon


Rephrasing the question........

Posted by Ron on June 22, 2001 12:29 PM

Maybe I should rephrase the question. When the user opens this workbook, I have a userform display. The user must enter data in that form which follows a wizard-like format.

If the user has other workbooks open at the same time, they can't use them since this userform displays on top of the windows in any workbook within the Excel application. I would like the user to be able to go to another open workbook, use it and return to this one. I need the userform to be hidden or not display when the user moves to another workbook. Hope that's little clearer.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.