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?

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?

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?

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?

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?