See David McRitchie's "getting started with VBA and macros" site.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Don't forget the Macro Recorder which most times gives you an idea of what has
to be done.
Tweaking of the recorded code is necessary in some cases.
Tushar Mehta has a tutorial on tweaking recorder-generated code.
http://www.tushar-mehta.com/excel/vb...rder/index.htm
Gord Dibben MS Excel MVP
On Fri, 9 May 2008 22:00:00 -0700, melmac
wrote:
hi everyone,
I'm really intrested in learing how to use macros. Anyone who can provide a
link where i can learn using macros in excel step by step? Or perhaps
documents i can refer to? I do have bit of knwledge bout VB programming,
however when i try checking out if i can do macros....hehehehe i failed, it's
quite hard to refer to the cells, or sheets or even obtaining the value of a
certain cell. The properties pane is so limited. Unlike with having a form in
VB, all the objects are there, all you need to do is name them and you can
easily program events and what not. I do hope someone can help me.
Thanks,
melmac