Microsoft Visual Basic

[Grace]

I have dabbled in macros in EXCEL (or was it LOTUS) years
ago but somehow missed the boat when Microsoft Visual
Basic for EXCEL was introduced. I know how to record a
macro but that's about it. I really need to learn more so
I can program or edit recorded steps. It is my perhaps
wrong uncerstanding that the Microsoft Visual Basic is
simpler than the true Visual Basic. If so, can someone
recommend a book or text wherein I can learn what I need
for EXCEL macros? Is it in the help file?

Thanks!

 

[Nick]

Grace

VB takes sometime to work out, but you really only learn
with examples of things that you need to get done. the
best way is to record macros and then read them (ALT+F11)
to see what code is used.

A good book is Excel/VB for Dummies or there is a much
more detailed book by John Walkenbach (of the www.j-
walk.com, fame).

good luck
Nick

 

[Grace]

Nick, is VBA for EXCEL indeed easier than what seems to be
referrred to as Visual Basic Net? If so, does the latter
reference text you mentioned have more of the latter?
Does the Dummies book tell you how to edit recorded macros
and dimension things, etc?

 

[Peo Sjoblom]

You seem rather determined to learn Excel, get the power programming book by
John Walkenbach instead.

 

[Jeff Johnson [MVP: VB]]

Nick, is VBA for EXCEL indeed easier than what seems to be
referrred to as Visual Basic Net? If so, does the latter
reference text you mentioned have more of the latter?
Does the Dummies book tell you how to edit recorded macros
and dimension things, etc?

(Warning, biased opinion ahead!)

Visual Basic.NET is NOT Visual Basic. VBA for Excel (and all Office
products) is closely related to the full-blown Visual Basic programming
language. There are differences, but once you know one, you basically know
the other, so your original statement:

is wrong (as you guessed), because "Microsoft Visual Basic" (by which I
assume you mean VBA) and "true Visual Basic" (VB6 and earlier) are virtually
the same language, so neither is really easier than the other.

 

[Grace]

Actually, I have seen enough to realize it will be a
challenge at best. And I don't think I'll be wanting to
learn to do anything too, too hard core or clever and am
wanting to ease my learning. So if you think the Dummies
book can do the job without intimidating and overwhelming
me, I'd prefer that. I'm looking for the intro course
beyond just recording macros.

What do you think!