I was wondering how to go about programming Macros into Excel? I am a mediocre Excel user that can write a couple of formulas but I want Excel to be able to scratch my *** at the click of a button..any good links or advise? I have burned up the pages of my beginners excel book, and I now am left fiending for more.
2006-09-26 17:04:05 · 3 answers · asked by james_spader_jr 3 in Computers & Internet ➔ Programming & Design
Look on your tools and macros. Start by recording a new macro. Do something interesting such as format some cells etc and then stop recording. Then in tools look in macros and select edit. Start to understand what the different commands do. Change them and see what the changes are. If you break teh macro and can't fix it, record another one.
When you record a macro that second little button switches between relative and absolute references. Absolute will always start from the cell you started when you commenced recording. Relative will start from wherever you have the cursor.
You could also try this http://www.functionx.com/vbaexcel/index.htm
Have fun!
2006-09-26 17:09:26 · answer #1 · answered by teef_au 6 · 0⤊ 0⤋
Buttons that scratch your itch are fun to program. I like the Intermediate book suggestions, but the best suggestion is the 'record a macro and see what the code is underlying it' suggestion. I do that regularly.
Great macros start with the desire to make your work easier. A task you do that is tedious and regularly is a prime candidate.
Well here's how to attach your brand new macro to the button. First record your macro, edit it and maybe debug it so it works. Then, be sure the place you want your button is in clear view.
Do View Toolbars, Forms. The button tool looks like a button. Click it and go back to your workbook and draw it on your sheet. Start at one corner and drag your cursor to the opposite corner.
Excel opens an Assign Macro wizard. Select your macro by its name and click OK.
You can edit the text on the button and change the size and location of the button too.
The site linked below suggests a good book for programming reference: Microsoft® Excel 2000 Power Programming with VBA by John Walkenbach
Have Fun!
2006-09-28 12:37:31 · answer #2 · answered by Ken C. 6 · 0⤊ 0⤋
To program macros you need to learn Visual Basic for Applications. It's the same as regular Visual Basic except it has its object model extended to encompass your Excel document. Buy a book or search online.
2006-09-27 00:07:35 · answer #3 · answered by jacinablackbox 4 · 0⤊ 0⤋