ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Record Macro - Record custom user actions (https://www.excelbanter.com/excel-programming/319456-record-macro-record-custom-user-actions.html)

Sal[_4_]

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


Sal[_4_]

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