Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning values application.dialogs(...).show | Excel Programming | |||
Application.Dialogs(xlDialogSendMail).Show | Excel Programming | |||
application.dialogs(xlDialogPrint) - arguments | Excel Programming | |||
Problems with application.Dialogs(xlDialogFormulaFind).Show | Excel Programming | |||
Named arguments for built in dialogs | Excel Programming |