VBA in Excel for newbies

sophlowe45

Hi

I want to start learning VBA in Excel, can anyone here point me to any good websites or books or other resources?

Thanks

newlywed

VBA for dummies is a really good book. Highly recommend it.

I mainly learnt via Word and this site was excellent: http://word.mvps.org/FAQs/OfficeInterdev.htm

Sorry that doesn't help a huge amount with Excel but there are only minor differences really.

patwa_2

I think I have a few ebooks lying about on the subject, they're on the server at the moment but I could check them out in the morning if you like?

H.

Lakeuk

Recommend Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets (Visual Blueprint) as a starter, lots the screenshots to make it easier to learn the basics before moving on.

http://www.amazon.co.uk/Excel-Programming-Blueprint-Interactive-Spreadsheets/dp/0764597817/ref=sr_1_2/202-3731498-8958207?ie=UTF8&s=books&qid=1184405043&sr=8-2

sophlowe45

thanks everyone for your replies...

Jaxer

This is a useful starting point:

http://www.excel-vba.com/excel-vba-contents.htm

rumpelstiltskin_2

This is an excellent site for all things excel.

http://www.ozgrid.com/forum/

Make sure you read their rules, the moderators are very strict!

rmg1

There's also http://www.mrexcel.com/board2/viewforum.php

You'll normally find me on there a couple of times a day with loads of others and the answers come thick and fast (usually!).

::edit::

I nearly forgot, I also have 4 books in pdf format if you want me to whizz them over. Total about 77MB though.

Richie(UK)

Both the OzGrid and MrExcel forums are excellent sources of information. Not only that, they provide a valuable way in which you can greatly accelerate your VBA learning - try to answer the questions that other people ask, then compare your solution to those offered by other posters.

MrExcel (Bill Jelen) also has a VBA book : http://www.mrexcel.com/vbabook.html

Two other websites that will be useful as you learn are :
http://j-walk.com/ss/excel/index.htm
and
http://www.cpearson.com/excel/topic.aspx

Good luck