Previous in Forum: Unable to Print   Next in Forum: Microsoft Ordered to Stop Selling MS Word
Close
Close
Close
10 comments
Rate Comments: Nested
Commentator

Join Date: Oct 2008
Location: India
Posts: 76

Macros in Microsoft Excel

08/12/2009 11:42 PM

Hi,

Can anyone suggest a resource to help me learn to use macros in MS Excel?

Hari

__________________
[Information is knowledge]
Register to Reply
User-tagged by 4 users
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru
United Kingdom - Member - Indeterminate Engineering Fields - Control Engineering - New Member

Join Date: Jan 2007
Location: In the bothy, 7 chains down the line from Dodman's Lane level crossing, in the nation formerly known as Great Britain. Kettle's on.
Posts: 32175
Good Answers: 839
#1

Re: Macro - How to Use Resources?

08/13/2009 4:24 AM

Consult a software training centre locally. Many of these sort of places offer tutorials on this sort of topic.

__________________
"Did you get my e-mail?" - "The biggest problem in communication is the illusion that it has taken place" - George Bernard Shaw, 1856
Register to Reply
Power-User
Engineering Fields - Electrical Engineering - New Member

Join Date: Aug 2007
Location: Toronto
Posts: 239
Good Answers: 9
#2

Re: Macros in Microsoft Excel

08/13/2009 10:09 AM

The simplest way is to Record a Macro while doing some common tasks like selecting ranges, changing fonts, moving columns, etc. Then, open the macro in VBA and study the methods that were used. For specific questions and usable macros, Google for "Excel VBA Macros". There are many good sites available with free macros. I've written probably close to a hundred macros over the years and own several VBA and macro books, but I've rarely used them since the 'net is much more relevant.

Grae

Register to Reply Score 1 for Good Answer
Anonymous Poster
#5
In reply to #2

Re: Macros in Microsoft Excel

08/14/2009 5:47 AM

I fully agree the best way to learn is to record a macro and edit it. But the complications come when you need logical tests to be carried out by the macro. Here, one must learn a few tricks of creating loops and using logical functions. The way out is try and learn. Mahess

Register to Reply
Power-User
Engineering Fields - Electrical Engineering - New Member

Join Date: Aug 2007
Location: Toronto
Posts: 239
Good Answers: 9
#3

Re: Macros in Microsoft Excel

08/13/2009 10:34 AM

Here's a link to a pretty good site with lots of free macros. Study these to get a feel, then tweak them as you wish.

http://www.ozgrid.com/VBA/

Grae

Register to Reply
Guru
United Kingdom - Member - Hearts of Oak Popular Science - Paleontology - New Member Engineering Fields - Mechanical Engineering - New Member

Join Date: May 2005
Location: In the Garden
Posts: 3389
Good Answers: 75
#4

Re: Macros in Microsoft Excel

08/14/2009 3:35 AM

Read the help files.

Get "Excel for Dummies" and "VBA for Dummies"

Play and practice.

That's how I did it.

__________________
Chaos always wins because it's better organised.
Register to Reply
Active Contributor

Join Date: Apr 2008
Location: Chicago, IL
Posts: 12
#6

Re: Macros in Microsoft Excel

08/14/2009 10:13 AM

"VBA for Modelers" by Albright is a text that i used during school. Provides the intro to a modeling concepts and then a elecronic copy of the "answer" model in the attached CD - even the answers are modeled differently, which provides good feedback.

Your typical textbook with concepts and workbook-ish problems but I still refernce it for seldomly used tricks that i forget all too often.

Comment your code!

__________________
~ Give my regards to the chef
Register to Reply
Power-User
Engineering Fields - Electrical Engineering - New Member

Join Date: Aug 2007
Location: Toronto
Posts: 239
Good Answers: 9
#7
In reply to #6

Re: Macros in Microsoft Excel

08/14/2009 10:19 AM

Good point. Commenting your code can not be stressed enough. Also, try to adopt a consistent method of terminology. What may seem intuitively obvious as you write the code, could very well leave you scratching your head months later.

Grae

Register to Reply
Power-User
United Kingdom - Member - New Member Engineering Fields - Energy Engineering - New Member Engineering Fields - Piping Design Engineering - New Member Fans of Old Computers - Commodore 64 - New Member Technical Fields - Technical Writing - New Member

Join Date: Jun 2007
Location: Windsor UK
Posts: 103
Good Answers: 1
#8

Re: Macros in Microsoft Excel

08/14/2009 10:55 AM

I would recommend Mr Excel

http://www.mrexcel.com/

Macrotastic

__________________
Those who believe in telekinetics, raise my hand - Kurt Vonnegut
Register to Reply
Guru
Engineering Fields - Electromechanical Engineering - Technical Services Manager Canada - Member - Army brat Popular Science - Cosmology - What is Time and what is Energy? Technical Fields - Architecture - Draftsperson Hobbies - RC Aircraft - New Member

Join Date: Sep 2006
Location: Clive, Alberta, Canada
Posts: 5916
Good Answers: 204
#9

Re: Macros in Microsoft Excel

08/16/2009 5:24 PM

vba is just a subset of vb, yet vb can be easier to learn, as there is not a need to know a lot about excel. There is a ton of help out there for vb. my fav is www.vb-helper.com, as there is a lot of free downloadable projects and knowledge.

after that, simply recording your own macros, and reading them will be best.

Chris

Register to Reply
Active Contributor

Join Date: Jul 2009
Location: Malaysia
Posts: 10
#10
In reply to #9

Re: Macros in Microsoft Excel

03/09/2011 11:07 PM

Hi, Thanks for all the helpful tip and guide you guys given, it did give me some clue how to go about! Moi

Register to Reply
Register to Reply 10 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

Anonymous Poster (1); chrisg288 (1); design-engineer (1); English Rose (1); Graebeard (3); Living_d_Dream (1); PWSlack (1); shmoi (1)

Previous in Forum: Unable to Print   Next in Forum: Microsoft Ordered to Stop Selling MS Word

Advertisement