Sub ShowForm
UserForm1.Show
End Sub

Attach to a macro button you place on the QAT or a Command Button on a
worksheet.

Not sure what you mean by "run the form independently of the spreadsheet"

What do you consider as a "spreadsheet"?

Worksheet or Workbook?


Gord Dibben MS Excel MVP


On Tue, 23 Mar 2010 11:16:07 -0700, MaryamB
wrote:

Hi,

I have created a form using teh developer tab in excel in vb. The problem
is anytime I want to access the form i need to go to the developer tab, click
on vb and run it frorm there. What I would like to do is to bring the form to
the spreadsheet so that I can run it directly from there. or better yet, be
able to run the form independently of the spreadhseet. is that a possibility?

Thanks a lot for your help,

Maryam