When using an Office product, it is sometimes necessary to create your own custom functions or macros to aid in your automation processing. To create a custom macro/function is relatively easy. Simply follow these steps:
1. Make sure you have an Office product open then
hit ALT+F11. You should see Microsoft Visual
Basic editor open in a separate window.
2. Decide where you wish to include your custom
method. If you'd like to have your macro
available everytime you open the application,
then click on the appropriate folder: Excel: PERSONAL.XLS Outlook: Project1 Word: Normal
If, instead, you would like to associate your
macro only with a specific file, then click on
that file.
3. Once you have selected the appropriate file,
right-click on it and select Insert>Module.
An editor screen should open up which will allow
you to type in your custom function/macro.
A few points to remember:
In order to run a custom Macro, you can hit ALT+F8 and select the macro you wish to run or you can go to Tools>Macro>Macros.
In Excel, if you wish to run a custom function, then you simply type in the function as you would any other function.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.