how do i bring a visual basic form to the spread sheet?

[MaryamB]

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

 

[Jim Thomlinson]

add a button to the spreadsheet and attach the code
UserForm1.show 'or whatever the form name is

You will not be able to run the form independant of XL...

 

[Gord Dibben]

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