VBA Forms

[frost]

Hello,

I've created a vba form in excel which allows user to enter data. The form
is started using a macro.

Once the form is opened, I cannot access the worksheets until the form is
closed.

Is it possible to access the worksheets when a form is currently running ?
If so how can I do this ?

Thanks in adavnce.

 

[Guest]

Sub showform()
UserForm1.Show vbModeless
End Sub

 

[JW]

Hello,

I've created a vba form in excel which allows user to enter data. The form
is started using a macro.

Once the form is opened, I cannot access the worksheets until the form is
closed.

Is it possible to access the worksheets when a form is currently running ?
If so how can I do this ?

Thanks in adavnce.

Depends on what version of Excel you are running. If you are using
Excel 2000 or higher, you can set the form to modeless when you
initially open the form. It can be done in prior versions as well,
but requires some API calls and such.
Sub showForm()
UserForm1.Show vbModeless
End Sub

 

[Gary Keramidas]

or just view the forms properties, go down to showmodal and change the value to
false.