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?

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" wrote in message
...
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?

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" wrote:

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" wrote in message
...
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?

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)



"BHatMJ" wrote in message
...
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" wrote:

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" wrote in message
...
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?