How can i memorise the Macro Commands?

[Angel]

Hi there,

The Macro Commands are so complex? Different function has different command,
how can i memorise all of them? please give me some suggestions!

 

[papou]

Hi
My only personnal suggestion: practise and practise again and again!
;-)

HTH
Cordially
Pascal

 

[dksaluki]

Hi there,

The Macro Commands are so complex? Different function has different command,
how can i memorise all of them? please give me some suggestions!

i don't think it's possible to memorize it all. do you know how many
objects/methods/properties there are?!!! you will learn alot the
more you use vba, but you should get comfortable using the Excel
Object Model.

 

[JP]

Build up a good reference library so you can refer to functions as
needed. I posted a short list on my site:

http://www.codeforexcelandoutlook.com/programmer_library.html

And check out this site for a great list:

http://www.contextures.com/xlbooks.html


HTH,
JP