Openning a workbook while a userform is running

[ProteanBeing]

I want the userform of a workbook to be open but still be able to use excel (ie open other workbooks, update sheets in the current workbook).
Is this possible?

[blackie42]

Do you mean is it possible to have a workbook open and user form (for updating sheets in that workbok) but also pen another workbook and change edit that (but not with the userform attached to first workbook).
If so ans = yes cos I've just done it.

Jon

[ProteanBeing]

how...:motz2:

[blackie42]

In a module write a procedure to open the form like...

And assign to commandbutton in sheet (to open form)

Sub Openform()
form.Show 0
End Sub

Put a 0 (zero) after the show (and space) makes the form modal or modeless (can't quite remember which but hey it works). This means you can use excel as normal while form is still showing.

[rory]

Modeless. :)
This works with XL2000 upwards - there is a workaround for XL97 if that's applicable.