Results 1 to 4 of 4

Thread: Need some information on creating Macros

  1. #1
    Join Date
    Mar 2009
    Posts
    29

    Need some information on creating Macros

    Hi,
    I had never used Macros before. I have to finish up a project work in which I have create Macros related to the provided query. I had tried the same by reading some information from Microsoft Help. But that only taught the basic information on it. I need a proper setup guide to create and run minor Macros in Microsoft Excel. Thanks in advance.

  2. #2
    Join Date
    May 2008
    Posts
    4,348

    Re: Need some information on creating Macros

    Here are some instructions to create a simple macro programs. First move to cell A1 and type in your name. For example, abc and press Enter Go back to cell A1, because when you gave Enter or change cell under the direction. Then click the View menu, followed by the Toolbars option and select Visual Basic. Now the Bar is activated. Click on the Save Macro button, the one with the blue scroll wheel. Active Windows dialog box
    Record Macro, which will give the name to the macro and what is the shortcut to run it. The shortcut you mean by that point the macro will obviously be activated with the Ctrl key and the letter you want, preferably in lowercase, because if you select the Capitalize macro is activated by pressing Shift + Ctrl + the letter you indicated.

  3. #3
    Join Date
    May 2008
    Posts
    4,834

    Re: Need some information on creating Macros

    To observe the code of a macro must follow the following steps. First move to cell where you have created one, before you start recording the Macro Press the Macro Record button in the Visual Basic toolbar. Excel displays the Chart. Record Macro dialog. Shortcut option in the type the letter r, so the macro is called with Ctrl + r. Press the OK button. Excel starts recording the Macro1.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,089

    Re: Need some information on creating Macros

    I will list you a simple example to create forms in Microsoft Excel using Macro. Press Alt + F11 to enter the Visual Basic editor. Activate the following options: Click on the View menu and choose Project Explorer. Click on the View menu and choose Properties Window. From the Insert menu choose UserForm. This inserts the Form.

Similar Threads

  1. Excel Autosorting without Macros
    By rnwatson in forum Windows Software
    Replies: 1
    Last Post: 28-02-2012, 06:33 AM
  2. What is the use of macros in the word?
    By bharti_rajpal in forum Windows Software
    Replies: 3
    Last Post: 07-12-2009, 12:41 PM
  3. How to Run Excel Macros from ASP
    By Chain-SmokeR in forum Software Development
    Replies: 2
    Last Post: 04-07-2009, 12:23 PM
  4. Macros in Word
    By DanB in forum Windows Software
    Replies: 1
    Last Post: 02-06-2009, 08:09 AM
  5. What is MACROS in programming?
    By Claudius in forum Software Development
    Replies: 3
    Last Post: 06-03-2009, 11:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •