Learning VBA via Recorder

[DerbyDad03]

Many years ago I taught myself VBA for Excel by doing a lot of
recording and then cleaning up the code with tips and tricks gleaned
from various forums. I'd like to think I've gotten pretty good at it.

I'm now trying to do that with Word, but the recorder doesn't seem to
be anywhere near as friendly. In Excel, you can perform any user
function with the recorder running and it's like it's not even there.

In Word, I seem to be extremely hampered by the recorder - I can't
even select text with the mouse, I have to use Shift-Arrow keys.

Is there some trick to being able to ignore the recorder and navigate
a document in a "normal" manner when it is running?

Thanks!

 

[Jay Freedman]

Unfortunately, what you see is what's there. Not only are there many things
the recorder won't let you do, but the code it records needs *lots* of
cleanup (although it's a great learning experience <g>).

Here are a couple of references to help you along:
http://www.word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
http://www.word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[DerbyDad03]

Thanks!

I know I should get over it, but it never ceases to amaze me that the
only thing truly common amongst the products in the Microsoft Office
suite is the name Microsoft!