show a userform and still work on the below worskheet?

[Valeria]

Dear experts,
I would like to show a chart on an excel spreadsheet and keep it apparent on
the worksheet while users work at the data. A userform would be ideal,
however I do not know if it is possible to keep a userform open on a sheet
and still be able to input data on the worksheet?

Many thanks for your reply.
Best regards

 

[JP Ronse]

Hi Valeria,

It is possible to have a ueserform open and input data on the worksheet if
you set the ShowModal property of the form to False.

Wkr,


JP

 

[Patrick Molloy]

the default mode for showing userforms is modal, but show modeless and you
can still work on the sheet:

Sub main()
UserForm1.Show vbModeless
End Sub

 

[Chip Pearson]

You can show the form modessly. E.,g,

UserForm1.Show vbModeless

Note, though, that the code will continue to execute statements after
the Show method, without waiting for the user to do anything. This may
be an issue if there is code following the Show method that relies on
the user having made some sort of input on the form.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)