D DLx/P Posts: 98 +0 Oct 8, 2003 #1 What is the best and easiest way to learn to write macros in Excel? My GM at work is bugging me to learn this. He said he would pay for any classes, books etc. that I may need. Might as well take advantage of this.
What is the best and easiest way to learn to write macros in Excel? My GM at work is bugging me to learn this. He said he would pay for any classes, books etc. that I may need. Might as well take advantage of this.
Nic Posts: 1,519 +1 Oct 8, 2003 #2 Record a macro in Excel, then view it in the code editor. Classes and books would also help. Maybe even some multimedia video training (expensive).
Record a macro in Excel, then view it in the code editor. Classes and books would also help. Maybe even some multimedia video training (expensive).
D DLx/P Posts: 98 +0 Oct 8, 2003 #3 Record a macro in Excel, then view it in the code editor. Click to expand... Thats just it, I don't have a clue on how to record/write a macro. I can get around with writing formulas. But macros are a different monster.
Record a macro in Excel, then view it in the code editor. Click to expand... Thats just it, I don't have a clue on how to record/write a macro. I can get around with writing formulas. But macros are a different monster.
StormBringer Posts: 2,218 +0 Oct 9, 2003 #5 See if this helps http://mars.wnec.edu/~jerzy/XL/macros.html
D DLx/P Posts: 98 +0 Oct 10, 2003 #6 Thanks alot Storm, that is probably the best step by step information I have seen yet.