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