Excel/vba book recommendation?

[jmcash]

Hi,
I have gotten really good at recording macros in excel using my knowledge of excel, complicated formulas, and keyboard shortcuts and a little (very little) bit of code editing (like changing a cell reference and copying and pasting previously used code). But since I don't know vba I'm forced to use extremely complicated work arounds for simple processes. These macros work just fine but are a pain to record and take longer to create than they probably should.

I want to learn about loops, dim, and variables and more vba vocab.

Is there a book out there that you could recommend for someone who already knows their way around macros but needs to go to the next step in vba?

Thanks.

 

[Domski]

Hi,

I don't actually have it but you could look at Bill's (Mr Excel) own book:

http://www.mrexcel.com/store/index.php?l=product_detail&p=49

I have John Walkenbach's Excel 2003 Power Programming with VBA which I mainly use just to clarify my understanding of what something does and is excellent, don't forget the VBA help also.

I only really play around with VBA and use it to automate the odd task at work but would suggest for really learning about VBA hang around the forum and see what some of the more capable VBA'ers post. If you want to understand something there's no harm in asking.

Best of luck.

Dom

 

[xenou]

I'm a big fan of John Walkenbach's Excel VBA Programming for Dummies for a first book in VBA.

Alex