LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
returning values application.dialogs(...).show Pringles. Excel Programming 2 July 31st 06 04:11 PM
Application.Dialogs(xlDialogSendMail).Show James T Excel Programming 1 July 18th 06 03:34 AM
application.dialogs(xlDialogPrint) - arguments David Excel Programming 0 October 17th 05 08:01 AM
Problems with application.Dialogs(xlDialogFormulaFind).Show lydya Excel Programming 2 December 18th 04 05:02 PM
Named arguments for built in dialogs Jan Kronsell[_3_] Excel Programming 5 December 9th 03 04:48 PM


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"