Sarah has attended:
Excel VBA Intro Intermediate course
Adding additional items to a macro
Once you have finished recording a macro if there any way of adding in further functionality which has been recorded or would you have to write in the code manually in the visual basic editor?
RE: Adding additional items to a macro
Hi Sarah
Thank you for your question
Generally to add further functionality to a macro you would have to edit the code in the VBE.
However, if the new actions follow on after those in the first macro, simply record them as a second macro and the in the VBE create a procedure that calls the 2 macros sequentially
e.g.
Call Macro1
Call Macro2
Regards
Stephen