ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OnAction with arguments supported (https://www.excelbanter.com/excel-programming/355960-onaction-arguments-supported.html)

RB Smissaert

OnAction with arguments supported
 
I know you can do OnAction with arguments like this:
..OnAction = "'ShowINI strSys6000Path'"
with double quotes enclosing single quotes.
However I am not sure this is supported in all Excel versions.
I know it works 11, but will it work in version 9 and 10?

I know I can do .Parameter = strSys6000Path
and pick that up like this:
variable = CommandBars.ActionControl.Parameter
in my Sub or Function, but the first method is a bit neater.

RBS



All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com