We've all done this before -- we need to figure out how to do something in VBA, so we use the Macro Recorder (Tools -> Macro -> Record New Macro), do the action, then go to the VBA editor and see what was recorded. To clean up we delete the module.
Is there a way to do this without going through this process? Is there a plug in that will show every action a user takes as the VBA code in a separate window? Or is the Macro Recorder the only way to get this sort of insight?
Thanks!
Alon
Is there a way to do this without going through this process? Is there a plug in that will show every action a user takes as the VBA code in a separate window? Or is the Macro Recorder the only way to get this sort of insight?
Thanks!
Alon