Launching a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I inserted "MS Excel 5.0 Dialoge" and put some check boxes on it that run
some macros.

Question: How do I make this "Dialoge" form? show up.

I used another "Command Button" with the code

Unload DialogFrame1
But this gave me an error.

Thanks
 
hi,
attatch this code to a button or icon

Sub ShowForm()
UserForm1.Show 0 ' rename userform1 to your form name
AppActivate Application.Caption
End Sub

Regards
Frank
 
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

How to get a file from a web page 1
Access 2003 Access Error Form Name 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Enter Parameter Value in Access Form 0
Input form in Excel 2007 2
How to use multiple command button to copy user form data to multiple worksheet 0
INDATA and OUTDATA 7
Excel Data Form 2

Back
Top