Excel Dialog with arguments

[RonRepp]

Hi all:

I've never used an Excel Dialog with arguments.

Can someone point the way?

 With Application.Dialogs(xlDialogMailLogon)
   .Show
 End With

''cannot get this dialog to show???

Any help will be appreciated...


Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[combo]

Just pass arguments to 'Show' method:
With Application.Dialogs(xlDialogMailLogon)
.Show [!]Arg1, Arg2...[/!]
End With

combo

 

[michaelbr55]

The argument to pass to the dialog are

name_text, password_text, download_logical

ie

With Application.Dialogs(xlDialogMailLogon)
   .Show michael, 29837452, True
 End With

Michael Bryant
Southern Ocean Software

http://southernoceansoftware.com