Please help a Stinkin' Rookie get started!?!!

[Guest]

I need to learn VB for EXCEL yesterday! Someone told me I should just buy
Visual Basic 6.0 and learn by doing but I don't trust him. Is that the best
way to learn VB for EXCEL or is there some better way?

 

[Dave Patrick]

No, that isn't the way. Go to your local book store and get yourself a book
or two on the subject (excel VBA). You can also use the built-in macro
recorder to do some limited things then look at the code to see how it was
done.

This link is old but still mostly applies.
http://www.microsoft.com/officedev/articles/opg/

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I need to learn VB for EXCEL yesterday! Someone told me I should just buy
| Visual Basic 6.0 and learn by doing but I don't trust him. Is that the
best
| way to learn VB for EXCEL or is there some better way?
| --
| cyberindio

 

[Bob Phillips]

If you want it for Excel, why buy VB. Excel ships with VBA, which is Visual
Basic for Applications.

Then get a book. There are 3 stand-out books IMO

VBA For Dummies by John Walkenbach,
Power Programming With VBA by JW (again)
Excel VBA Programmer's Reference by John Green, Stephen Bullen & Rob Bovey
et al.

BTW, they will have an edition such as 2002, XP, 2003 in the title as well.
Avoid the Excel VBA Programmer's Reference 2003, go for the 2002 version as
I understand that the update has lost a lot


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks, Bob.
You saved my time and money.

If you want it for Excel, why buy VB. Excel ships with VBA, which is Visual
Basic for Applications.

Then get a book. There are 3 stand-out books IMO

VBA For Dummies by John Walkenbach,
Power Programming With VBA by JW (again)
Excel VBA Programmer's Reference by John Green, Stephen Bullen & Rob Bovey
et al.

BTW, they will have an edition such as 2002, XP, 2003 in the title as well.
Avoid the Excel VBA Programmer's Reference 2003, go for the 2002 version as
I understand that the update has lost a lot


--

HTH

RP
(remove nothere from the email address if mailing direct)