vba excel

[vba wannabe]

Greetings

I am really baffled by all those vba jargons

Want to learn more. Can someone suggest a
site providing simple step by step instruction
to learn excel vba

Thanks

 

[Ken Wright]

Format / Cells - Pick any numeric format, then hit custom and put a comma at
the end of each segment, eg if you just used number then you would have

0.00 so add comma to get
0.00,

or from 0 to 0,

Accounting as an example

_-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_- to
_-£* #,##0.00,_-;-£* #,##0.00,_-;_-£* "-"??_-;_-@_-

Each comma will reduce by factor of 1000, so 2 commas give you millions etc

 

[Ken Wright]

Grrrrrrrr - was on wrong post - sorry

 

[Gord Dibben]

A good place to start is David McRitchie's "getting started with VBA"

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Note: at bottom of page are links to more resources.

One of the links will lead you to this site which has some good material, but
David's pages will probably be ample for now.

http://snipurl.com/d8y8


Gord Dibben Excel MVP