User Form - Make It Appear

  • Thread starter Thread starter Celtic_Avenger
  • Start date Start date
C

Celtic_Avenger

This one must be simple.

I just cant figure it out.

SeaparkJohn has suggested using a User Form instead of a dialog shee
for a menu system.

I have created the User Form, But now I need to write a macro linked t
a command button to make it appear, and dissapear.

What is the code to do this?

Thanks for your help.

Celtic_Avenge
 
Sorry,

Probably should have elaborated.

Assume your userform is called USERFORM1

the code to make it appear is userform1.show

to make it disappear is unload Userform1

SJ
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock Position Of User Form In VBA 1
Dialog Box Wont Dissapear Before Continuing Selection Macro 1
Access Automatically Send a notification email once a record is added 0
How to use multiple command button to copy user form data to multiple worksheet 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Export as pdf form to ipad 2
How to get a file from a web page 1
Excel Data Form 2

Back
Top