| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Goto Special Dialog
I know you can use VBA to display many of Excel's built in Dialogs but I
don't see the Goto Special (F5) dialog as one of them. Does anyone know a way to display the GoTo Special dialog with VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Goto Special Dialog
Hi Frank,
Try: Application.Dialogs(xlDialogFormulaGoto).Show --- Regards, Norman "Frank" wrote in message ... I know you can use VBA to display many of Excel's built in Dialogs but I don't see the Goto Special (F5) dialog as one of them. Does anyone know a way to display the GoTo Special dialog with VBA? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Goto Special Dialog
Application.Dialogs(xlDialogFormulaGoto).Show
.... shows the Goto dialog. I want to display the 'Goto Special' dialog. The one that comes up when you click the Special... button on the Goto dialog. Frank "Norman Jones" wrote: Hi Frank, Try: Application.Dialogs(xlDialogFormulaGoto).Show --- Regards, Norman "Frank" wrote in message ... I know you can use VBA to display many of Excel's built in Dialogs but I don't see the Goto Special (F5) dialog as one of them. Does anyone know a way to display the GoTo Special dialog with VBA? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Goto Special Dialog
Hi Frank,
Application.Dialogs(xlDialogSelectSpecial).Show --- Regards, Norman "Frank" wrote in message ... Application.Dialogs(xlDialogFormulaGoto).Show ... shows the Goto dialog. I want to display the 'Goto Special' dialog. The one that comes up when you click the Special... button on the Goto dialog. Frank "Norman Jones" wrote: Hi Frank, Try: Application.Dialogs(xlDialogFormulaGoto).Show --- Regards, Norman "Frank" wrote in message ... I know you can use VBA to display many of Excel's built in Dialogs but I don't see the Goto Special (F5) dialog as one of them. Does anyone know a way to display the GoTo Special dialog with VBA? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Goto Special Dialog
Thanks Norman
Frank "Norman Jones" wrote: Hi Frank, Application.Dialogs(xlDialogSelectSpecial).Show --- Regards, Norman "Frank" wrote in message ... Application.Dialogs(xlDialogFormulaGoto).Show ... shows the Goto dialog. I want to display the 'Goto Special' dialog. The one that comes up when you click the Special... button on the Goto dialog. Frank "Norman Jones" wrote: Hi Frank, Try: Application.Dialogs(xlDialogFormulaGoto).Show --- Regards, Norman "Frank" wrote in message ... I know you can use VBA to display many of Excel's built in Dialogs but I don't see the Goto Special (F5) dialog as one of them. Does anyone know a way to display the GoTo Special dialog with VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What happened to my special paste dialog box? | Excel Discussion (Misc queries) | |||
| Paste Special Dialog Not Correct | Excel Discussion (Misc queries) | |||
| Paste Special dialog box | Excel Discussion (Misc queries) | |||
| Inserting items into the Paste Special Dialog box | Excel Programming | |||
| Special cmdbar button activating Enable Macro dialog | Excel Programming | |||
![Frank[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
