Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need some information on creating Macros

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-10-2009
Member
 
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.

Reply With Quote
  #2  
Old 30-10-2009
Member
 
Join Date: May 2008
Posts: 4,338
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.
Reply With Quote
  #3  
Old 30-10-2009
Member
 
Join Date: May 2008
Posts: 4,826
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.
Reply With Quote
  #4  
Old 30-10-2009
Member
 
Join Date: Apr 2008
Posts: 4,092
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need some information on creating Macros"
Thread Thread Starter Forum Replies Last Post
Excel Autosorting without Macros rnwatson Windows Software 1 28-02-2012 06:33 AM
What is the use of macros in the word? bharti_rajpal Windows Software 3 07-12-2009 12:41 PM
How to Run Excel Macros from ASP Chain-SmokeR Software Development 2 04-07-2009 12:23 PM
Macros in Word DanB Windows Software 1 02-06-2009 08:09 AM
What is MACROS in programming? Claudius Software Development 3 06-03-2009 11:49 AM


All times are GMT +5.5. The time now is 07:00 PM.