The fastest way to learn enough VBA for excel , enough to customize spreadsheets

---

Request for Question Clarification by maniac-ga on 28 Oct 2005 14:55 PDT

Hello Bluekat,

There are several good tutorials available on Excel and Visual Basic
for Applications. If you provide a little insight into the kinds of
things you want to do with VBA, I can point you directly to the
relevant material as well as the more general information.

  --Maniac

In Excel, go to Help, select Help for Excel. Using Search type in VBA.
That should give you a very good start.

Congratulations on wanting to learn more. You are about to start a
journey that will be quite frustrating, and also very satisfying. Good
Luck to you!

My mother used to call me for help, and I would direct her to a
specific help topic. She would say, "Why can't you just tell me
exactly what to write?" I always responded because by doing the
searching the trial and error herself, she would grow in knowledge.

Most likely your journey into VBA, won't be easy, but I encourage you
to stick with it, it is confusing at first but if you stick with it,
eventually it begins to make sense. Really use the Help Topics. Once
you get used to them, your knowledge and skills will expand
exponentially. Struggling through 1 help topic, trying to get it to
work for you will be hard, but the next one perhaps will be a little
less hard. It gets better is what I am trying to say. Try not to go to
VBA User groups to quickly for answers, tough it out and figure it out
for yourself.

Again Good Luck, I wish you much much Success!!!!!!!!!!!!!!!!!

First determine what action you want to perform. For example you might
want to format a table specifying column widths to auto-adjust to
contents. If you want to know how this is done in VBA,
1. go to Tools->Macro->record new macro. 
2. Press okay for the next dialogue box that pops up asking name of
macro. A new toolbar called "stop recording" can be seen now.
3. perform your action of adjusting the column widths to auto adjust to contents.
4. after you finish with your activity then press the stop button on
the "stop recording" toolbar
5. go to tools->macro->macros (alternately press Alt+f8) and select
the recorded macro. then press edit button. This will open VB Editor
for MSExcel showing the code for the activity performed.

In this way for any activity you wish to perform first make excel do
it and then modify the code to learn and perform your desired tasks.