none
Excel built in function builder place on form RRS feed

  • Question

  • is there a way to take the built in function builder (Fx) and place that button on a form. Thanks.
    Monday, January 14, 2019 3:35 PM

Answers

  • You can use the following line in the code for the button:

        Application.Dialogs(xlDialogFunctionWizard).Show


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by James N San Monday, January 14, 2019 7:07 PM
    Monday, January 14, 2019 3:45 PM

All replies

  • You can use the following line in the code for the button:

        Application.Dialogs(xlDialogFunctionWizard).Show


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by James N San Monday, January 14, 2019 7:07 PM
    Monday, January 14, 2019 3:45 PM
  • Works perfectly. Thanks
    Monday, January 14, 2019 7:06 PM