Reference Text Advance VBA Programming

michaeldh

Board Regular
Joined
Jun 11, 2002
Messages
201
Hi Guys,

I was hoping someone might be able to recommend a good text book which contains Advanced Excel VBA programming. I am at an Intermediate type level but wish to go much further with my learing to master the language.

Any tips would be appreciated.

Michael.

:biggrin:
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
"Visit Mr Excel's Bookshelf" !! :LOL:

Alternatively, if you're at an intermediate level then a reference text might be useful. I find that the O'Reilly "nutshell" books are very good in this respect.
 

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
Actually I might just take that back. I've had a little poke around and the VBA nutshell book also caters for pure VB. Some people didn't like this aspect.

I would recommend going to Amazon and doing a search for "VBA". You'll get loads of ideas there.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Michael

I can heartily recommend both "VBA and Macros" by Bill Jelen and "Excel 2002 VBA Programmer's Reference" by Bullen et al. Note, for the progammer's ref one, it is the 2002 version and not the 2003 (change of authorship).

I think that you would also find very useful the Holy Macro!2,200 VBA Examples CD from Mr Excel (again) - it will give you a serious amount of VB code to pick apart, digest and adapt to whatever situations you have.

Best regards

Richard
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,129
Messages
5,857,542
Members
431,885
Latest member
Rsdg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top