Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |