Learning to use macros

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

see http://www.mvps.org/dmcritchie/excel/getstarted.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"xirokx" <xirokx.227khm_1138222501.0417@excelforum-nospam.com> wrote in
message news:xirokx.227khm_1138222501.0417@excelforum-nospam.com...
>
> 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
>
>
> --
> xirokx
> ------------------------------------------------------------------------
> xirokx's Profile:
http://www.excelforum.com/member.php...o&userid=25533
> View this thread: http://www.excelforum.com/showthread...hreadid=505096
>

Hi Xirokx,

As you are new to macros, I would suggest that you visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials

The VBA material is towards the end of that section.


---
Regards,
Norman


"xirokx" <xirokx.227khm_1138222501.0417@excelforum-nospam.com> wrote in
message news:xirokx.227khm_1138222501.0417@excelforum-nospam.com...
>
> 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
>
>
> --
> xirokx
> ------------------------------------------------------------------------
> xirokx's Profile:
> http://www.excelforum.com/member.php...o&userid=25533
> View this thread: http://www.excelforum.com/showthread...hreadid=505096
>

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

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.


---
Regards,
Norman



"xirokx" <xirokx.227uwm_1138236000.5759@excelforum-nospam.com> wrote in
message news:xirokx.227uwm_1138236000.5759@excelforum-nospam.com...
>
> 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
>
>
> --
> xirokx
> ------------------------------------------------------------------------
> xirokx's Profile:
> http://www.excelforum.com/member.php...o&userid=25533
> View this thread: http://www.excelforum.com/showthread...hreadid=505096
>