Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Eden Jones   on Oct 07 In MS Office Category.

  
Question Answered By: Corbin Jones   on Oct 07

As a beginner in VBA do you also mean that you are a beginner in
programming? If yes then just starting to learn  VBA is like starting to
learn any programming language and would require that you have to
understand some logic on writing programs. I do not mean the high level
stuff like pointer arithmetic or data structures but the simple stuff  like
sorting algorithms, or using decision statements, string manipulations
etc.

If no then Walkenbach is good. Also books by Curtis Frye and books on
Excel 200X Inside Out series are good.

A really good book is Writing excel  macros with VBA by Steven Roman
(Oreilly). An important feature of this book unlike the other books is
that he discusses the Excel object model in detail.

Websites which could help  you out are www.ozgrid.com,
www.techonthenet.com, www.mrexcel.com.

If you are planning on becoming good at excel career wise try not to use
the recorder very often. Try to understand the Excel object model.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Learning VBA/macros from scatch Or get search suggestion and latest updates.


Tagged: