#1   Report Post  
vba wannabe
 
Posts: n/a
Default 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   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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   Report Post  
Ken Wright
 
Posts: n/a
Default

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   Report Post  
Ken Wright
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
html to excel nellie Excel Discussion (Misc queries) 4 February 8th 05 10:37 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Merge from Excel to Excel dalstar Excel Discussion (Misc queries) 3 January 30th 05 02:37 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Shortcut file fails to open JimH Excel Discussion (Misc queries) 3 January 15th 05 10:13 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"