Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gettiiing Started in VBA
Hi,
I am totally new to VBA. But I can see the need for its use in writing macros, etc. What is the easiest and simplest way to get started? Tx, Sat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gettiiing Started in VBA
Hi! Welcome to the club. I'm only about half a step ahead of you. Here's
what I've done: 1. Use the macro recorder to create your first macros. Alt+F11 will take you into the VB Editor, where you can look at the code to see what commands were used to do what. 2. Spend time just reading here on the newsgroups. There's a lot of stuff talked about, and the more you read it the more you get to understand. 3. Search for answers. Use the Help files in the VB Editor. Get a book at your level. I had zero experience with any tyoe of programming, so I got VBA for Dummies to find out what an object was and so forth. If you're above that, there's lots of books that will take you deeper. 4. Post here with things you don't understand or get stuck on. These MVPs are fantastic! Often it will be something fairly simple (missing a space, wrong object, etc.), and an experienced eye really helps. 5. Check out the web sites recommended within the answers on the newsgroups. Lots of tips, answers, code, book recommendations, etc. 6. Jump in, make mistakes, fix them, and feel great when it works! Ed "saturnin02" wrote in message ... Hi, I am totally new to VBA. But I can see the need for its use in writing macros, etc. What is the easiest and simplest way to get started? Tx, Sat |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gettiiing Started in VBA
I recommend books by John Walkenbach, a fine writer.
"saturnin02" wrote in message ... Hi, I am totally new to VBA. But I can see the need for its use in writing macros, etc. What is the easiest and simplest way to get started? Tx, Sat |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gettiiing Started in VBA
And there are a ton of sites with infor.
Start with this one - www.rondebruin.nl/Google.htm Ron has an Add-In that you can download free of charge. It installs a search tool under your Help menu in Excel. If you don't Google search Excel problems now, you will soon do so when you get the hang of it. Some Tutorials http://www.mvps.org/dmcritchie/excel/getstarted.htm http://maths.sci.shu.ac.uk/units/ioa/ http://www.j-walk.com/ss/books/bookxl19.htm http://support.microsoft.com/default...content/vba101 /default.asp Some of the MVP's http://www.j-walk.com/ss/excel http://www.cpearson.com/excel http://www.bmsltd.co.uk/mvp/ http://www.mvps.org/dmcritchie/excel/ http://www.contextures.com/xlbooks.html http://tushar-mehta.com/ I am sure that I missed a bunch (forgive me all). But you'll find references to them in the ng. Ed's advice is great! Especially the order in which he listed stuff. I personnally recommend the Dummy book because it is short and sweet and jumps you right in. steve "Ed" wrote in message ... Hi! Welcome to the club. I'm only about half a step ahead of you. Here's what I've done: 1. Use the macro recorder to create your first macros. Alt+F11 will take you into the VB Editor, where you can look at the code to see what commands were used to do what. 2. Spend time just reading here on the newsgroups. There's a lot of stuff talked about, and the more you read it the more you get to understand. 3. Search for answers. Use the Help files in the VB Editor. Get a book at your level. I had zero experience with any tyoe of programming, so I got VBA for Dummies to find out what an object was and so forth. If you're above that, there's lots of books that will take you deeper. 4. Post here with things you don't understand or get stuck on. These MVPs are fantastic! Often it will be something fairly simple (missing a space, wrong object, etc.), and an experienced eye really helps. 5. Check out the web sites recommended within the answers on the newsgroups. Lots of tips, answers, code, book recommendations, etc. 6. Jump in, make mistakes, fix them, and feel great when it works! Ed "saturnin02" wrote in message ... Hi, I am totally new to VBA. But I can see the need for its use in writing macros, etc. What is the easiest and simplest way to get started? Tx, Sat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting started tab | New Users to Excel | |||
VBA Getting Started | Excel Discussion (Misc queries) | |||
Getting Started Pane | New Users to Excel | |||
getting started pane | Excel Discussion (Misc queries) | |||
How to get started with VBA and macros? | Excel Discussion (Misc queries) |