Question about Business & Productivity Software

Open Question

Rumba Macro Help

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

Posted by on

6 Suggested Answers

SeaJade
  • 104 Answers

SOURCE: Macro through excel

What did you actually want to do with it as Macro VBA coding is rather large?

Posted on Oct 28, 2007

  • 171 Answers

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:

http://www.anthony-vba.kefra.com/

Posted on Jan 28, 2008

PCBuilda
  • 101 Answers

SOURCE: Excel Macro to find out non-keyboard ascii characters

Not a macro but if you need a particular code for a symbol. Try Start button and then run
type charmap
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

  • 359 Answers

SOURCE: Office 2007 Standard - VBA not working

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

TheAssembler
  • 9 Answers

SOURCE: macro

Hi motilal

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.

Regards,
TheAssembler

Posted on Jun 06, 2008

  • 39 Answers

SOURCE: Macro solution to search for character within a text string.

Use Instr: If (Instr(yourString, "/")) then ...

Posted on May 27, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi, I've go a VBA macro that runs fine in Excel 2003 but I get the Run time error '-2147467259 (80004005)': Method 'MaximumScale' of object 'Axis' failed I'll send you the macro if you want. A small t...


I assume you mean that it's fine in 2003 but errors in 2007? If this is the case, then you may want to check the protection on the sheet. With 2007, you will run into this error everytime the macro tries to update a password protected sheet or portion of a sheet.

Hope this helps!

Oct 02, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Can anyone help me. I want to write a macro that goes to a cell and waits for the user to input something then moves to the next cell (down) when the user presses enter and repeats the process until the...


There is function called INPUT, which opens an input window and waits for user input. The input is stored in macro cell and you can refer to it later. To get to the end of (or top of) use SELECT.END and you will go from the active cell to the first blank cell up, down, left or right depending on the argument you enter. These are Macro Version 4.0 functions and there are similar functions in VBA RHands

Jun 08, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Use of a graphic for my signature


I would use a macro. Go to the View tab, and at the far right you'll see the Macros dropdown. Select "Record Macro" and give it a name like MySig. Assign your macro to a button to place its icon on your Quick Access Toolbar at the very top along with the Save, Undo, Redo, etc. You may wish to change the default macro symbol -- just click the "Modify" button to choose from a wide assortment of icons. You can also assign a keyboard shortcut by clicking the Keyboard button and choosing your key combo.
Then step through your macro. I clicked the Insert tab, then Picture, and selected my signature image. Once that is placed on the page, go back to your Macros dropdown and select "Stop Recording."
Voilà! Please let me know if you have any other questions.
Best,
~~Cheryl

Dec 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Macros


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

1 Answer

Macro


Hi alwinkumar

You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.

Private Sub resetForm()

'formname.itemname = value
UserForm1.Label1 = "Hello World"

End Sub

For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below

numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count

Jul 16, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Macro


Hi motilal

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.

Regards,
TheAssembler

May 06, 2008 | Microsoft Excel for PC

1 Answer

Macro


Sure,

Private Sub Workbook_Open()
Application.OnTime TimeValue("15:00:00"), "MyMacro"
End Sub

This will run the Procedure MyMacro at 15:00 each day.

Mar 19, 2008 | Business & Productivity Software

1 Answer

Microsoft Excel Formula


Hi, probably the easiest way would be to create a macro and attach it to a button which would automatically sort the required column in descending order. When Excel does this it reorders the whole list so that the names correspond correctly. To do this you simply go to the tools menu and select macros and "record new macro" then click any cell in the results that make that person coming first etc, then click the sort descending button on the toolbar, then click stop record.
Afterwards create a button from the "toolbox controls" and then view the code for both the button and the macro and copy the macro code and paste it into the "click" option for the button.
If you need an example or anything else give me a yell.
Regards
SeaJade

Mar 05, 2008 | Microsoft Excel for PC

1 Answer

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:

http://www.anthony-vba.kefra.com/

Jan 28, 2008 | Business & Productivity Software

1 Answer

HOW TO USE MACROS


Dear ROCKY open Tool Menu-Macro-record new mecro-give the macro file name like rocky-do your work when you finish your job then stop button mecro and save it . next day when you do same job on other file then again open macro and run your macro file and get same job on your new file

Sep 20, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

572 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...