If one added a button in the excel custom bar calling a sub (a macro) is it possible to pass an argument to that sub?
Why? I have several old macros and each called by its button. I realised that I could potentially merged 3 macros into 1 and based on the argument do the appropriate branch in the macro
I would still have 3 buttons but each passing a different argument
Button1(mymacro(1))
Button2(mymacro(2))
Button3(mymacro(3))
Thanks
John
Why? I have several old macros and each called by its button. I realised that I could potentially merged 3 macros into 1 and based on the argument do the appropriate branch in the macro
I would still have 3 buttons but each passing a different argument
Button1(mymacro(1))
Button2(mymacro(2))
Button3(mymacro(3))
Thanks
John