VBA in backend and GUI in frontend .. RRS feed

  • Question

  • Hi,

    I have already written vba code to perform multiple operations .. and have a button that runs the code .. all I want to do now is ..sync it with a GUI .. like an exe file which opens with say 2-3 buttons and when clicked it performs the same operation .. will it be possible to do it ? do we need java or anyother language to do so ? please let me know .. any help is appreciated ..

    Monday, June 11, 2012 1:06 PM

All replies

  • Hi Sriramtgo,

    Where is your current button located?

    I suspect you ar elooking for a userform (in VBA editor) with a couple of buttons?

    But you can also create a custom ribbon with the buttons.
    There are many possibilites, which is best depends on what your goal is.

    Regards, Jan Karel Pieterse|Excel MVP|
    Monday, June 11, 2012 1:46 PM