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.

Sub showform()
UserForm1.Show vbModeless
End Sub

"frost" wrote:

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.

On Sep 27, 8:26 pm, "frost" wrote:
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

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

--


Gary


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