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

  • Thread starter Thread starter MaryamB
  • Start date Start date
M

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
 
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...
 
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
 
Back
Top