Making a form visible

  • Thread starter asa.flynt.reynolds
  • Start date
A

asa.flynt.reynolds

I have a spreadsheet that has several buttons on it. I want to move
the buttons to a form and have a single button on the spreadsheet. I
have created the form and cant figure out how to make it visible when
i click on the button on the spreadsheet. Any help would be
appreciated.
 
E

Earl Kiosterud

flynt,

Is the form you've created a Userform (created in the Visual Basic for Applications
environment), or a worksheet form (you put your buttons on another worksheet?

Are you OK with putting macros in your workbook?
 
A

asa.flynt.reynolds

The form that i have created is a Userform. And, yes, I am okay with
putting a macro in the workbook. I have several already.
 
E

Earl Kiosterud

Flynt,

If the name of your userform is UserForm1 (default), in your macro, show the form with
UserForm1.Show.
 
Top