![]() |
Record Macro - Record custom user actions
Is there a way to have Excel record custom user actions (say like a
user executing a Addin function by clicking on a custom toolbar button) in addition to standard Excel actions during macro recording? I know you can program VBA code that adds/deletes/edits VBA code using VBA objects like 'VBIDE' & 'VBProject.VBComponents'. So if not explicitly, can this be done as a 'hack' by implementing VBA code that writes VBA code?... so during 'Record Macro' it would add my own code to that which Excel is recording programmetically based on the user executed custom calls that i can detect? Thanks in advance. Salvatore Anzalone |
Record Macro - Record custom user actions
After further research, i realized it can in fact be done without using
'VBIDE' & 'VBProject.VBComponents'. The built in excel VBA command is 'Application.RecordMacro([code to record])'. See Excel VBA help for 'Application.RecordMacro' for more info. thankyou to me! |
All times are GMT +1. The time now is 01:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com