MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Video Tutorial

  Asked By: Bertha    Date: Nov 25    Category: MS Office    Views: 1385

I could record short and
simple macros but can not write them on my own. I also tried to learn on my own
referring though books but in vain. Could any one suggest whether any Video
tutorials are available on the net so that I can improve my understanding about



1 Answer Found

Answer #1    Answered By: Grady Stewart     Answered On: Nov 25

I bet there is some type of video  tutorial out there.
But I'm more of a "hands-on" kind of guy.
What you're asking is like saying:
"I have a car, but is there a video to show me how to drive".
sure. you can find a video, but until you actually get behind the wheel
and start down the road, you really can't get the feeling.. you know?

As the saying goes:
"If you don't know where you're going, any road will take you there"

You need a PURPOSE, some objective so you know when you've arrived.
Look through the emails in this group and try to solve the problems yourself.
they'll help you branch out into areas you normally wouldn't travel.

You act like "writing" macros  and "record short and simple" macros is not the
same thing.
Many, many times, when I need to do add something to one of my macros,
I'll record  what I want to do, then copy/paste it into my macro and modify it
to work with my application.

I've got a spreadsheet with nearly 11,000 lines of code backing it up.
I need to modify it so that records with a specific attribute are changed to
and the background changed to blue.
I recorded a macro to change the font and color, then in the code where I
locate the line in question, I copied in the recorded code.
I don't waste my time trying to remember the syntax to "write it on my own"...

I'd say you need to learn  how to use the VBA debugger, Watch window and
Immediate Window.

Didn't find what you were looking for? Find more on Video Tutorial Or get search suggestion and latest updates.