Display a Custom Dialog Box

[BHatMJ]

I have a button on a worksheet created from the Forms toolbar. I'd like to
display a dialog box if this button is clicked but am having trouble showing
the dialog box from a subroutine in a module. Can anyone point me in the
right direction?

 

[Bob Phillips]

Do you mean a custom userform? If so, just

Userform1.Show

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[BHatMJ]

Yes, it's a custom userform. I changed the name of the form to "dlgHelp".
Using the command dlgHelp.Show did not work. However, I re-created the form
and did not rename it and, surprisingly, Userform1.Show works. Thanks for
the help.

 

[Bob Phillips]

If you rename it now, does it still work?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)