vba excel
 

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

try this url
http://spreadsheets.about.com/cs/exc.../vba1index.htm


vba wannabe wrote in message
...
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

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"vba wannabe" wrote in message
...
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

Grrrrrrrr - was on wrong post - sorry

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" wrote in message
...
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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"vba wannabe" wrote in message
...
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

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

On Sat, 5 Mar 2005 03:08:56 -0800, "vba wannabe"
wrote:

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