Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000/Visual Basic -- I need to learn...
I want to teach myself Visual Basic in my limited free time. Can anyone
point me in the direction of the most efficient/free way to do this? I am a hands-on learner and I learn best by example and duplicating tasks then creating my own. Is there a good reference website out there of VB code/formulas? I am of limited income and I am looking to educate myself to further my job opportunities. Thanks for your help!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000/Visual Basic -- I need to learn...
The macro recorder is a good place to start. Record some macros and look at
the code that is generated. This helps learn how vba refers to things. Bear in mind, some parts of the code generated by the recorder is unnecessary (such as scrolling, selecting, and activating things) mvps.org (under the Excel section) has some good links to websites w/code samples. I think David McRitchies has some tutorials. Two others that I can remember: xldynamic.com mcgimpsey.com If you can afford some books, John Walkenbach has a few (j-walk.com). Some of the mvps websites have suggested reading materials. And I've found this newsgroup to be a great place to learn. Some of the posters include their websites in their signature, so additional places to check out. "CMIConnie" wrote: I want to teach myself Visual Basic in my limited free time. Can anyone point me in the direction of the most efficient/free way to do this? I am a hands-on learner and I learn best by example and duplicating tasks then creating my own. Is there a good reference website out there of VB code/formulas? I am of limited income and I am looking to educate myself to further my job opportunities. Thanks for your help!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000/Visual Basic -- I need to learn...
Thank you, JMB! I will check out the sources you recommended. It's a start
:) I used to know Basic about 15 years ago, so hopefully that is a good start. "JMB" wrote: The macro recorder is a good place to start. Record some macros and look at the code that is generated. This helps learn how vba refers to things. Bear in mind, some parts of the code generated by the recorder is unnecessary (such as scrolling, selecting, and activating things) mvps.org (under the Excel section) has some good links to websites w/code samples. I think David McRitchies has some tutorials. Two others that I can remember: xldynamic.com mcgimpsey.com If you can afford some books, John Walkenbach has a few (j-walk.com). Some of the mvps websites have suggested reading materials. And I've found this newsgroup to be a great place to learn. Some of the posters include their websites in their signature, so additional places to check out. "CMIConnie" wrote: I want to teach myself Visual Basic in my limited free time. Can anyone point me in the direction of the most efficient/free way to do this? I am a hands-on learner and I learn best by example and duplicating tasks then creating my own. Is there a good reference website out there of VB code/formulas? I am of limited income and I am looking to educate myself to further my job opportunities. Thanks for your help!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000/Visual Basic -- I need to learn...
Connie
One of the best sources I have seen is these Excel newsgroups. They a microsoft.public.excel microsoft.public.excel.misc microsoft.public.excel.newusers microsoft.public.excel.programming microsoft.public.excel.worksheet.functions The programming newsgroup leans more heavily on programming but they all get into programming in various degrees. By perusing these newsgroups you will see literally thousands of real questions posted by real people as well as responses to those questions. The opportunity to learn is right there in black and white. You can also post your own questions and get prompt help. There are also many books available. The most helpful I have found are the series of books by John Walkenback. They are titled Microsoft Excel XXXX Power Programming With VBA. The XXXX is the latest version of Excel covered by that book. For instance, I have 2000 and 2003. Each book covers all versions up to and including the title version, so your best bet is to get the latest version of the book. Amazon.com is what I have found to be the cheapest source. HTH Otto "CMIConnie" wrote in message ... I want to teach myself Visual Basic in my limited free time. Can anyone point me in the direction of the most efficient/free way to do this? I am a hands-on learner and I learn best by example and duplicating tasks then creating my own. Is there a good reference website out there of VB code/formulas? I am of limited income and I am looking to educate myself to further my job opportunities. Thanks for your help!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000/Visual Basic -- I need to learn...
Thanks for your reply! Isn't this technology wonderful? I will check out
the resources you recommended. Connie :) "Otto Moehrbach" wrote: Connie One of the best sources I have seen is these Excel newsgroups. They a microsoft.public.excel microsoft.public.excel.misc microsoft.public.excel.newusers microsoft.public.excel.programming microsoft.public.excel.worksheet.functions The programming newsgroup leans more heavily on programming but they all get into programming in various degrees. By perusing these newsgroups you will see literally thousands of real questions posted by real people as well as responses to those questions. The opportunity to learn is right there in black and white. You can also post your own questions and get prompt help. There are also many books available. The most helpful I have found are the series of books by John Walkenback. They are titled Microsoft Excel XXXX Power Programming With VBA. The XXXX is the latest version of Excel covered by that book. For instance, I have 2000 and 2003. Each book covers all versions up to and including the title version, so your best bet is to get the latest version of the book. Amazon.com is what I have found to be the cheapest source. HTH Otto "CMIConnie" wrote in message ... I want to teach myself Visual Basic in my limited free time. Can anyone point me in the direction of the most efficient/free way to do this? I am a hands-on learner and I learn best by example and duplicating tasks then creating my own. Is there a good reference website out there of VB code/formulas? I am of limited income and I am looking to educate myself to further my job opportunities. Thanks for your help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very Basic Excel Tutorial | Excel Discussion (Misc queries) | |||
Excel does not open a basic worksheet | Excel Discussion (Misc queries) | |||
Excel and Visual Basic | Excel Discussion (Misc queries) | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
I need to learn how do do excel workbooks, how do I take an onlin. | New Users to Excel |