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

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" <(E-Mail Removed)> wrote in message
news:96E0C166-EEE0-40EE-AC2D-(E-Mail Removed)...
> 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