Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
User Record | Excel Worksheet Functions | |||
Macro to record user name and date/time | Excel Discussion (Misc queries) | |||
Move to Next Record with User Form | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |