Learn Excel Programming
 

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
--
Cheers !

Learn Excel Programming
 

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


On 2 Aug, 10:36, Sena wrote:
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
--
Cheers !

Learn Excel Programming
 

On Aug 2, 5:36 am, Sena wrote:
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
--
Cheers !

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

Learn Excel Programming
 

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.

"Sena" wrote:

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
--
Cheers !

Learn Excel Programming
 

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

"Stu" wrote:

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.

"Sena" wrote:

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
--
Cheers !

Learn Excel Programming
 

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/vb...rder/index.htm


Gord Dibben MS Excel MVP

On Sat, 4 Aug 2007 12:46:13 -0700, Smitty
wrote:

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

"Stu" wrote:

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.

"Sena" wrote:

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
--
Cheers !