PDA

View Full Version : use spreadsheet when running form



fraser5002
12-02-2008, 12:35 AM
Hi how am i amble to use a spreadsheet whilst running a form . i.e to manually graph up data. At the moment when the form is running i cannot change anything on the sheet.

i.e can i set focus to the sheet rather than the program?

Bob Phillips
12-02-2008, 01:34 AM
Open the form as modeless,



Userform1.Show vbModeless

fraser5002
12-02-2008, 01:44 AM
hmm im getting the error cant show non modal form when modal form is displayed? I put the code in form activate is this right?

Bob Phillips
12-02-2008, 02:07 AM
Well, the error message says it all. If you have already opened a form, that should be modeless too.