How to learn Macros in excel?

[mathsbeauty]

Hello! How can I master the Macros in Excel? Should I learn the visual basic, vb.net first? I do know C and C++ programming language? Is there any ebook for learning macros in excel? Any suggestions please.

 

[gbell3587]

Hello! How can I master the Macros in Excel? Should I learn the visual basic, vb.net first? I do know C and C++ programming language? Is there any ebook for learning macros in excel? Any suggestions please.

If you know a couple of programming languages, it wont take long to adapt to the syntax. The way i learned was by recording how to do some stuff e.g select a range of cells, copy & paste, run conditional formatiing etc and then just look at how the code is made up.

 

[VoG]

Take a look at Hiker's list http://www.mrexcel.com/forum/showpost.php?p=2676997&postcount=5