Creating a very basic macro

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

trainerjc

Thread Starter
Joined
Jul 3, 2007
Messages
2
I am writing training material to teach users how to create macros in Excel 2003. We will only be using the macro recorder, no VBA. I am looking for suggestions that would be "real world" examples. To give you an idea, the material I'm updating contains macros for adding a header/footer, another for applying formatting to a range and a third for changing page orientation. The examples need to be fairly generic because the students come from various backgrounds and professions. I am having a hard time coming up with additional examples that don't seem to be contrived.
TIA,
Trainerjc
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Copy & Paste.
Copy & Paste Special as text.
Print Out a Sheet.
Save a Workbook.
Open a Related Workbook.
Find Some Text or Number.
 
Joined
Sep 4, 2003
Messages
4,916
Autosize Columns
Insert / Delete Rows
Hide Columns / Rows
Rename Worksheets
Copy Worksheet to New Workbook
Insert Worksheet / Delete Worksheet
Freeze Panes / Rows
Print Selection
Sort Data
AutoFilter

Regards,
Rollin
 
Joined
Jul 25, 2004
Messages
5,458
Hello Trainerjc, welcome to the board!

This seems to be a misnomer, but macros are in fact VBA. The only Office application which macros are not VBA is Access. VBA is the language in which your recorded macros are written by the macro recorder. When you record a macro and you view it (Alt + F11, opening the Visual Basic Editor), that is the programming language you see, VBA.

As far as your dilemma goes, there are some fine examples provided by both OBP and Rollin. I would try to think of it in terms of, "what do you do in Excel manually and what would it look like recorded by a macro?" Not everything is picked up by the macro recorder either.

Some things I would stay away from is importing/exporting data, connecting with external data sources, web queries, text to columns or creating objects (i.e. drawing objects, forms controls or control toolbox controls). The code generated from these are generally very difficult to understand for a novice. Also, if you do record your own macros, try not to select any unnecessary cells or scroll if necessary. This will always be portrayed in your code. I really advocate the macro recorder and should be everyone's best friend. If you're stuck with a piece of code, try the macro recorder to get a working syntax.

Hope This Helps

(Heya OBP/Rollin!)
 
Joined
Sep 4, 2003
Messages
4,916
Zack,

Haven't seen you around for a while it's nice to have you back. For a minute there we thought you didn't love us any more :D

Regards,
Rollin
 
Joined
Jul 25, 2004
Messages
5,458
Hi guys,

I've started taking my prerequisites for my Paramedic, been keeping me busy. Haven't had much time for the forums, but of course I still love ya. Trying to get back in my spare time, catch as catch can really. Always enjoy seeing the friendly faces/names though. :)
 

trainerjc

Thread Starter
Joined
Jul 3, 2007
Messages
2
Thanks for your suggestions. I do realize that the macro recorder is creating VBA. What I meant was that we would only be using it and not manually coding VBA. These are novice users and looking at the VBA editor is overwhelming for them right now. Thanks again!
 
Joined
Jul 5, 2007
Messages
53
Hi

I have used simple Macros for the following:

Entering autotext such as addresses/names/header and footer paragraphs (I know Autotext can do this, but it serves as an example and some people liek saying they use 'macros', makes them feel/sound tecchie).

All kinds of formatting. Certain styles preferred by the user. Again, Styles would be better here, but it serves the purpose again.

Hope this helps.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top