Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Jun 16, 2018

vba command button for macro dialog box not working

Instead of clicking Developer > macro to open macro dialog box (or pressing ALT F8), I made a command button to open it by just one click (using the vba below), the problem is = the macros are not working!  what could be the problem?

I am using excel 2013

many thanks

 

Application.Dialogs(xlDialogRun).Show

excel
Macros and VBA

2 Replies

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Jun 28, 2018

    I am sort of re-posting this thread maybe somebody can give me some answer or solution to my query.

     

    Instead of clicking Developer > macro to open macro dialog box (or pressing ALT F8), I made a command button to open it by just one click (using the vba below),

    Application.Dialogs(xlDialogRun).Show

    the dialog box did pop up BUT the macros are not working!  what could be the problem?

    I am using excel 2013

    many thanks

     

     

    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Jun 29, 2018

      I would like to share to anyone who might be having the same scenario:

       

      Mr. Yongle had suggested to use SendKeys "% {F8}" 

      instead of Application.Dialogs(xlDialogRun).Show and it indeed worked..

      HTH