Looking for Excel 2003 VBA - training Links 3

[wec43wec]

Can anyone provide me with a link to a free web site that covers the initial learning stages of coding VBA for Excel 2003.

I am trying to increase my Excel knowledge through VBA coding and I need an understanding on how to write this code.

Thanks

 

[MajP]

VBA changes with each version of office, but not much. Yeah you get some new functions and objects but the basics are the same. If you pick up a vba book for 2000 or 2003 you will be fine. So do yourself a favor and surf the net for a cheap book. I have seen vba for Excel books on the web for $2.00. Check out ebay. Personlly, I find a book a lot easier than staring at a computer screen. You can also look at Goodwill, or a used book store. But you should be able to pick these up for a few bucks.

 

[Loomah]

hi
have you tried a simple google search?

otherwise the book option is a good one but you'll never beat actually coding.

follow sites like this one, look at the problems that are posted and think about how you might be able to solve them. then see what the actual responses to questions are - a lot of the time there will be more than 1 option.

i went on a 'proper' course some time ago which gave be the basic understanding of vba such as object models and syntax but didn't really start to learn until i was out of work and spent quite a bit of time here solving problems - a lot of which i had to research myself!

one key factor i did pick up from the course i did was that xl vba is much easier when you know how xl works - how would you do something manually etc.

take that to the next level and record yourself doing something and view the resulting code. this code will generally be static and unfriendly but you soon learn what's necessary and what you can ignore - eg
recorded code might be

range("a1:c10").select
selection.interior.colorindex = 6

you might relise that you won't always want range a1:c10 as it might expand so you could use current region as you might in a worksheet and record the code again to get

range("a1").currentregion.select
selection.interior.colorindex = 6

which is a little more dynamic and will allow your range to be expanded.

next you'll find out that there is no need to select the cells to apply changes so this would perforn the same task (only more efficiently)

range("a1").currentregion.interior.colorindex = 6

happy hunting!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[SkipVought]

Tek-Tips!

Browse and learn.

Yes, I have learned a lot here at Tek-Tips. But only because I see some solution that interests me and I try doing it myself.

IMHO, you have to tinker and play with code. For me, it's both a hobby and an avocation. Try stuff. Try to make it better, compact, faster.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

Loomah, MajP and Skip - Thanks for all of your comments. I will move forward with your suggestions.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/en-us/library/aa272254(office.11).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fumei]

I have to agree with everyone. Browse here and find questions posed, and solutions posted. Code code code. there is no substitute for actually trying (and often failing) things yourself. Failing often leads to greater understanding, especially if you are persistent about trying to understand WHY?

However, I would very strongly encourage you to follow PHV's suggestion/posted link. Really understanding structure and an object model helps.

Books are good, but only if you actually use them to actually code. It is the doing that makes the difference.

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry