Learning to use macros

X

xirokx

Hi,

I work as a purchasing assitant and after using excel for many years
just discovered macros can make my life so much easier when:

1)placing purchase orders i.e. inputting date, changing order number,
entering quantity, emailing it to relevant suppliers, changing company
name etc

2) using macros I can predict when I will be out of stock as the figure
in a cell will be highlighted in red so I can view all red type cells or
minus figures only

However as I do not know any thing about them I wondered if you guys
can help:

1) whats the best and simplest ways to learn basic macros that can help
me with the above 2 tasks?

2) does anyone already use macros and have the vb text I need to add to
the module? If that at all makes sense?

Rest assured this weekend I am on a mission to learn how to use macros
so that life can be made so much easier....

I am aiming to add a button on the actual worksheet or would you
recommend I add a shortcut to the tool bar?

Any help would be most appreciated with additional ideas

Thanks in advance, thank you very much
 
X

xirokx

First of all thanks for your help and advice....

Please clarify if it is imperative to know how to use VBA when learning
about macros?

Is it true when recording a macro the programming aspect is
automatically written in the module? Or do you have to write a set of
instructions for the macro to run properly?

Please confirm

Thanks in advance.....

P.S. any help re: using macros in purchasing would be most
appreciately, thank you
 
N

Norman Jones

Hi Xirokx,

The macro recorder is very useful but is also very inefficient and the
resultant code tends to be very inflexible. Typically, a recorded macro
requires some editing to render it applicable to any scenario other than the
snapshot environment in which it is recorded. Such editing presupposes a
knowledge of VBA.

If you intend to use macro functionality, I would strongly advise you to
visit the link suggested both by Bob and by me; I would also advise you to
pursue the tutorials link which I provided.
 
Top