ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can i memorise the Macro Commands? (https://www.excelbanter.com/excel-discussion-misc-queries/173195-how-can-i-memorise-macro-commands.html)

Angel

How can i memorise the Macro Commands?
 
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[_4_]

How can i memorise the Macro Commands?
 
Hi
My only personnal suggestion: practise and practise again and again!
;-)

HTH
Cordially
Pascal

"Angel" a écrit dans le message de news:
...
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!




dksaluki

How can i memorise the Macro Commands?
 
On Jan 16, 1:56*am, Angel wrote:
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[_4_]

How can i memorise the Macro Commands?
 
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.co...r_library.html

And check out this site for a great list:

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


HTH,
JP

On Jan 16, 1:56*am, Angel wrote:
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!




All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com