Program Flow with Modal UserForms

[ions]

Dear Excel Expert

I have a program with a series of Modal User forms popping up.

Depending on the user input within the UserForm I may want to present the user with a report in an Excel Worksheet.

Hence the possible program flow I am after is:

UserForm1 Modal.
UserForm2 Modal. ->> User Input requires a report created in a Worksheet.
Report WorkSheet (wait for user until done analyzing report)
Userform3 Modal
Userform4 Modal ->> User Input requires a report
Report WorkSheet (wait for user until done analyzing report)
Userform5 Modal
.
.
.
End Program.

Requirements: User Input requires a report created in a Worksheet:

User can view and scroll through the Report worksheet. Program Waits until they press PRINT or Cancel button. (buttons can be on a seperate UserForm or Embedded in the worksheet itself)

How do I make the program wait for the user to click Print or Cancel while they are using a worksheet? Can I make the worksheet modal?

If I make a Print Cancel Userform Modal I am assuming the user will not be able to manipulate the worksheet as program focus will be maintained on the Modal Userform.

Thank you very much for your input.

Peter.

[Richard Buttrey]

Hi,

I think you've got the general gist of the thing. By default User Forms come as Modal unless you set the ShowModal property to False.

The trick is to design your forms and buttons so that forms are made modal or modeless at the appopriate time. For instance if you have three user forms which are all set to Modeless to start with, and you load them all you can of course navigate anywhere and use whichever form/worksheet you want. Suppose you want to restrict the user to one of the forms, say Form 1, when you press a button on Form 2.

You can't change the modal state of a form whilst it's loaded, so in the click
event of the button you would have to include

Please Login or Register  to view this content.

Hope this gives you some ideas.