Your Status: Logged out Log in

Create a new macro  

Member rating: No Rating | Words: | Submitted: Tue Nov 16 2004

Page Preview
Preview
Previous 1 of 15 Next

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Create a new macro From the Tools menu, choose Macro, and click Macros. The following pop-up window appears: Type the name for the macro you want to make. For this example, type the name "MyFirstMacro". In general it is recommended to choose a name that reveals the purpose of the macro. For instance, if you are going to make a macro to generate normal random numbers, you could type the name "RndNormal", or if you want to write a macro that sorts body length data you can call it "SortBodyLength". Some characters are better not used in a name, which will be explained later in naming conventions. While you type a name for the new macro, the Create button on the pop-up window becomes active (useable). When you click Create, Microsoft Visual Basic Editor is started and a new macro is created with the name you chose. The new macro appears as...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 151,744 others
Register Now