Need help with VBA

[Mayank Prakash Gupta]

Hi,
I have to start developing VBA applications in Excel as a job assignment. I
therefore require a nice starting point to learn VBA in Excel. Can nebody
suggest some good books/links from where I can get complete and thorough
tutorials on Excel VBA? I need the resource to cover all topics from
beginner to the advanced level.

Regards
MPG

 

[Anne Troy]

Hi. Try www.VBAExpress.com. Lesson 1 of VBA Training is free.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Mayank Prakash Gupta]

thnx anne for the link...but i kinda do not want to spend so much on a web
tutorial...a free web resource was what i was looking for...

regards
MPG

 

[Anne Troy]

Right. Lesson 1 is free. It's a GREAT start. I wasn't suggesting you buy the
training. There's also a knowledgebase at www.vbaexpress.com/kb and you
can "steal" all the code you want. That's why it's there. There's many
simple macros with sample files.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Bob Phillips]

Get John Walkenbach's book, Excel VBA Programming For Dummies, some strong
black coffee, and start reading. It won't get you to advanced, but if you
are any good at it, it will get you to a point where you can develop to
advanced.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jef Gorbach]

Hi,
I have to start developing VBA applications in Excel as a job assignment. I
therefore require a nice starting point to learn VBA in Excel. Can nebody
suggest some good books/links from where I can get complete and thorough
tutorials on Excel VBA? I need the resource to cover all topics from
beginner to the advanced level.

Regards
MPG

- Macro Recorder is your friend.
- Google both usenet and general web for free code snippets
- Review microsoft.public.excel.* (esp .programming) daily
These free resources will become your best Coding allies.

Regarding books, I reccomend wandering your local bookstores because most of
the Beginner books cover the same materials so its more a matter of finding
an author's style you prefer over content.
MSFT Press offers indepth coverage on Medium/Advance topics in a very dry
upper college-text style.

 

[Jack Marks]

I tried starting the way all these other people suggested, and none of it
made much sense, since immediately I was faced with all sorts of terminology
that was unfamiliar. Without understanding what I was doing, there was no
way to proceed further. So, the way I really got going, was as follows:

1. Start Excel, with some data, and decide what you want to do, like copy
one row into another row.

2. Do Tools-Macro-record new macro, and write a simple key stroke macro, to
do almost anything, small.

3. Find the macro you just wrote. Look under tools-Macros-Edit.

4. Add your lines of Visual Basic.

5. This is the basic process. The rest is just a lot of complicated
details, most of which you don't need to know when you first start.