Dialogs(xlDialog...).Show arguments usage

[Peter E]

Hello everyone,

I have a problem finding out how to implement the possible arguments after
the Show method in this construction. They are summed up in the Help files,
but no example of how to use them. I'll give you my specific trial code which
I'm working on:

Sub NamesDialog()
Application.Dialogs(xlDialogDefineName).Show
(... some more code, hopefully from you)
End Sub

When I call this procedure, it automatically shows the text that is in the
active cell as a suggested name and below, in the RefEdit box, I see =R1C1. I
want to try to make the dialogbox show with both these fields being empty.

Can anyone help me?

 

[Bob Phillips]

Sub NamesDialog()
Application.Dialogs(xlDialogDefineName).Show "", ""
End Sub


--
HTH

Bob

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