Question about Business & Productivity Software
Hi all, i was wondering if anyone knows a way to have a Rumba macro run and place the cursor on the first blank line that is available. My Rumba setup will have 10 lines, with some filled in. I was wondering if there's a way to have the macro check the line and if it's got text to move on to the next line and check it.....TIA
SOURCE: macro on excel
Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.
You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.
To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK
(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)
4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.
Now your macro has been recorded! You can play it back later by:
1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"
The actions you performed earlier will now be executed.
Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:
1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"
(The visual basic editor will open, showing you the code for your macro)
At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.
Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.
If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:
Posted on Jan 28, 2008
Not a macro but if you need a particular code for a symbol. Try Start button and then run
You will find all the symbols here and in the bottom right hand corner it shows the keystrokes for selected symbol.
Posted on Mar 20, 2008
There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!
Posted on Apr 21, 2008
Follow these steps to create multiple macros
Click the Microsoft Office Button , and then click Excel Options.
In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.
Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.
In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.
Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.
Posted on Jun 06, 2008
Tips for a great answer:
Oct 02, 2009 | Microsoft Office Professional 2007 Full...
Jun 08, 2009 | Microsoft Office Excel 2003 for PC
Dec 01, 2008 | Microsoft Office Professional 2007 Full...
Aug 18, 2008 | Microsoft Excel for PC
Jul 16, 2008 | Microsoft Office Professional 2007 Full...
May 06, 2008 | Microsoft Excel for PC
Mar 05, 2008 | Microsoft Excel for PC
Jan 28, 2008 | Business & Productivity Software
Sep 20, 2007 | Microsoft Office Standard for PC
572 people viewed this question
Usually answered in minutes!