Dialogs(xlDialog...).Show arguments usage
 

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?
--
Peter E.
The Netherlands
XP+Office03

Dialogs(xlDialog...).Show arguments usage
 

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)

"Peter E" wrote in message
...
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?
--
Peter E.
The Netherlands
XP+Office03