Yay - I just did my first bit of VBA!!!

[doco]

I can see it all now - a couple years down the road when he is on a development team and the team leader calls a meeting to tell them: "Alright! You people start coding and I'll go see what they want.."

Wonder bout the xxxcitement then?

 

[Patience]

Hey all, I am still excited! But it is dead hard. Once i get properly over the first hurdle I think I will be fine. I will be the only person who knows it/sorta knows it, but then I am the only person here who understands what VLOOKUP is.

Onwards and upwards!

 

[SydneyGeek]

Getting a handle on the language can definitely be a hassle.

Like you said, the recorder is a good place to start -- especially once you know how to get rid of the crap afterwards (record a macro to change page orientation, and see what I mean).

Still, the best way to learn is getting your hands dirty -- up to the armpits!

Also, check out the thousands of examples on this site. There's some really cool approaches to solving problems that you can likely adapt, then pick apart to see how they worked.

Good luck!
Denis

 

[Greg Truby]

Congratulations on getting your feet wet in VBA. As you get some more experience you'll also begin to get a better feel for when to use VBA and when not to. For example - the code you posted? You could also have simply defined a new style and if you wanted customize your Formatting (or some other) toolbar by adding the Style listbox control to it. One of the things I seem to be seeing more frequently on the questions board is posters saying "I need a macro to..." when in fact they don't really need a macro at all.

Again, I don't mean to come across as discouraging! Quite the opposite in fact! You have taken the first steps into a bigger world. Once you start using VBA your possibilities will expand phenominally.

 

[Patience]

Again, I don't mean to come across as discouraging!

Not at all! Thank you for your advice. I realise that what I did was not really macro worthy, but it was about the simplest thing I could think of that I would use.

 

[Zack Barresse]

Congratulations Patience! That is quite nice to hear your excitement! Keep it up and you'll be learning more than you ever knew. :D