Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why VB in Excel?
Hello,
How do I get an introduction to VB? I am a new user to excel and my job involves using excel sheets often. I would like to optimize all my work. I understand that VB can help. Can someone give me info about what is VB and how to work on it? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why VB in Excel?
Kazuki
Excel (and other office applications) have a flavour of VB called VBA (Visual Basic For Applications), which has a similar syntax to VB but is specific to the objects in the particular applications, e.g Excel has Workbook, Worksheet, Range, Chart objects, etc, where Word has Document, Paragraph, Style, etc. You can record macros and then look at the resultant code (Alt+F11 to start the code editor after recording), as you will know what you did in the interface to get the code, although this route does record some pretty bloated code, it records all the defaults which are generally not necessary and uses the selection object a lot (Range...Select and then uses Selection.Copy), which is not the most efficient way to write code. I started with the Step by Step series book on Excel VBA, which builds a real application, you could then move onto the Power Programming series by John Walkenbach. I also have a reference to most of the user interface in Excel with an example of how to do it in VBA on my website at www.nickhodge.co.uk -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Kazuki" wrote in message ... Hello, How do I get an introduction to VB? I am a new user to excel and my job involves using excel sheets often. I would like to optimize all my work. I understand that VB can help. Can someone give me info about what is VB and how to work on it? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why VB in Excel?
Hi Kazuki,
You may also wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials --- Regards, Norman "Kazuki" wrote in message ... Hello, How do I get an introduction to VB? I am a new user to excel and my job involves using excel sheets often. I would like to optimize all my work. I understand that VB can help. Can someone give me info about what is VB and how to work on it? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why VB in Excel?
If you like "dead tree ware", here's a good book to get you started.
http://www.bookpool.com/sm/0764574124 You may even find some posts in these newsgroups from the author, John Walkenbach. -- Carlos "Kazuki" wrote in message ... Hello, How do I get an introduction to VB? I am a new user to excel and my job involves using excel sheets often. I would like to optimize all my work. I understand that VB can help. Can someone give me info about what is VB and how to work on it? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |