Learn Excel Programming

[Sena]

Hi,

I am quite good at normal worksheets and wish to learn a bit of programming
to automate ( basic stuff ). Is there website that I can refer to ?

Thanks

 

[bony_tony]

http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
Is quite easy to follow. The guy isn't trying to show off some of his
stuff, and keeps it simple.
After looking at the site, you can always search this group or ask any
questions if you are stuck.
I've learnt 99% of what I know through this group, only started on VBA
a couple of months ago.
Good luck
Tony

 

[tomcee]

Hi,

I am quite good at normal worksheets and wish to learn a bit of programming
to automate ( basic stuff ). Is there website that I can refer to ?

Thanks

I would highly recommend Mr. Walkenbach; both his books (Excel Power
Programming...) and website (which is at: http://j-walk.com/ss/excel/index.htm).

Tomcee

 

[Stu]

Yep, got to recommend Mr. Walkenbach's Power Programing. When it comes to VBA
he's the man, plus its a thick book so stops your papers blowing arround when
you not reading it.

 

[Smitty]

John's book are terrific and I have one on my desk too, but don't overlook
one of the most useful tools there is in the Macro Recorder. Bearing in mind
that it captures just about everything you do, so there is a bunch of
extraneous junk that can be weeded out. But learning what stays and goes a
long way to proper programming.

Hint: selecting is almost never necessary, so generally when you see
"Select" followed by "Selection" you can eliminate both statements and
concatenate the strings.

HTH,

Smitty

 

[Gord Dibben]

Further to Smitty's advice on the macro recorder, Tushar Mehta's section on
"beyond the macro recorder" has some good pointers on cleaning up the code.

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm


Gord Dibben MS Excel MVP