Launching a Form

J

Jeff

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
 
F

Frank Stone

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
 
Top