![]() |
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