Thread: VBA Forms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.