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

--
Valeria

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

"Valeria" wrote in message
...
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

--
Valeria

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



"Valeria" wrote:

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

--
Valeria

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)



On Fri, 4 Sep 2009 08:33:02 -0700, Valeria
wrote:

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