VBA Forms
 

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.

VBA Forms
 

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.

VBA Forms
 

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

VBA Forms
 

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.