ExcelBanter - Open Macro Dialog Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open Macro Dialog Box (https://www.excelbanter.com/excel-programming/305076-open-macro-dialog-box.html)

Steven

Open Macro Dialog Box

Alt + F8 will open the Macro dialog box.

How can I automate the Alt+F8 in a macro so the macro will
open the macro dialog box.

Thank you,

Steven

Norman Jones

Open Macro Dialog Box

Hi Steven,

Try:

Application.Dialogs(xlDialogRun).show

---
Regards,
Norman

"Steven" wrote in message
...
Alt + F8 will open the Macro dialog box.

How can I automate the Alt+F8 in a macro so the macro will
open the macro dialog box.

Thank you,

Steven

All times are GMT +1. The time now is 11:12 PM.