Hi everyone, I am very new to VBA and I am wanting to increase my knowledge in this area as I see that the potential within VBA is quite vast. I'm looking for something that is self paced either within a book or a website. Any suggestions?
New to VBA any suggestions
- Thread starter BartK
- Start date
- Local time
- Today, 12:18
- Joined
- Jan 23, 2006
- Messages
- 15,573
missinglinq
AWF VIP
- Local time
- Today, 12:18
- Joined
- Jun 20, 2003
- Messages
- 6,420
The FunctionX site Jdraw gave you is the one I always give when asked this question! It's fairly comprehensive and laid out well in appropriately named chapters.
Linq ;0)>
Linq ;0)>
ChrisO
Registered User.
- Local time
- Tomorrow, 02:18
- Joined
- Apr 30, 2003
- Messages
- 3,202
Bart.
As usual I will take a different tack.
1. Learn how to create a standard module.
2. Permanently turn on Option Explicit.
3. Learn how to save that module.
4. Start typing.
5. The F1 key is your friend.
6. If, after using the F1 help topics, you still get an error which you don’t understand, then ask.
Please don’t take this personally because over the years I have seen your question asked many times. This is only my interpretation of the question even if the people asking that question don’t realise it.
I want to be taught, I don’t want to learn.
I want to be taught everything; I don’t want to learn anything.
I want to be taught because it puts the onus of work on the teacher to teach, not on me to learn.
What I really want is some mystical transfer of information into my brain without doing the work to get it there.
It does not work that way; learning is a lot of work.
The internet is full of information; some of it true some of it not.
Without some method of learning, how would we know what we are being taught is correct, or not?
The method of learning is by testing but testing takes a lot of work.
Unless you just want to be taught then the first thing to learn is how to test.
To test something is a remarkably difficult thing to do. In fact testing and learning go hand in hand; one will not proceed without the other.
Therefore, start with a method of testing; type simple things and then test it.
Refine your testing methods along with what you learn.
Chris.
As usual I will take a different tack.
1. Learn how to create a standard module.
2. Permanently turn on Option Explicit.
3. Learn how to save that module.
4. Start typing.
5. The F1 key is your friend.
6. If, after using the F1 help topics, you still get an error which you don’t understand, then ask.
Please don’t take this personally because over the years I have seen your question asked many times. This is only my interpretation of the question even if the people asking that question don’t realise it.
I want to be taught, I don’t want to learn.
I want to be taught everything; I don’t want to learn anything.
I want to be taught because it puts the onus of work on the teacher to teach, not on me to learn.
What I really want is some mystical transfer of information into my brain without doing the work to get it there.
It does not work that way; learning is a lot of work.
The internet is full of information; some of it true some of it not.
Without some method of learning, how would we know what we are being taught is correct, or not?
The method of learning is by testing but testing takes a lot of work.
Unless you just want to be taught then the first thing to learn is how to test.
To test something is a remarkably difficult thing to do. In fact testing and learning go hand in hand; one will not proceed without the other.
Therefore, start with a method of testing; type simple things and then test it.
Refine your testing methods along with what you learn.
Chris.
- Local time
- Today, 17:18
- Joined
- Feb 19, 2013
- Messages
- 17,564
I agree with both suggestions.
The sites suggested by JDraw are very useful and ChrisO's point is very valid.
I believe the best way to learn is of neccessity and then practice. In the context of programming you have to have a project that is important to you so you can clearly define what it is you need to know and have a vision as to how it will work - otherwise it is a bit like have a car manual to learn about maintenance but not having a car to practice on!
It does surprise me how often questions on this and similar forums are vague in what is required and more importantly, do not provide the right or sufficient information for the responder to work with.
With the right information many threads could be answered in one or two responses but often extend to 10,20 or 30 or more because the original poster provides minimal information. I appreciate there can be a language barrier but it often feels like the original poster is trying to protect their 'intellectual property'.
Basics are often not learned, such as using reserved words, use of spaces in field and table names, understanding the different treatment of numbers, dates and text in queries, the difference between fields and controls, et al.
You have to start somewhere, so get yourself a project which has meaning to you and concentrate on getting it to work the way you want it to.
The sites suggested by JDraw are very useful and ChrisO's point is very valid.
I believe the best way to learn is of neccessity and then practice. In the context of programming you have to have a project that is important to you so you can clearly define what it is you need to know and have a vision as to how it will work - otherwise it is a bit like have a car manual to learn about maintenance but not having a car to practice on!
It does surprise me how often questions on this and similar forums are vague in what is required and more importantly, do not provide the right or sufficient information for the responder to work with.
With the right information many threads could be answered in one or two responses but often extend to 10,20 or 30 or more because the original poster provides minimal information. I appreciate there can be a language barrier but it often feels like the original poster is trying to protect their 'intellectual property'.
Basics are often not learned, such as using reserved words, use of spaces in field and table names, understanding the different treatment of numbers, dates and text in queries, the difference between fields and controls, et al.
You have to start somewhere, so get yourself a project which has meaning to you and concentrate on getting it to work the way you want it to.
missinglinq
AWF VIP
- Local time
- Today, 12:18
- Joined
- Jun 20, 2003
- Messages
- 6,420
I believe this is the second time this week I've said "Amen" to CJ's comments! In addition to those comments, please, please, please learn the names of objects/controls! Often the 10, 20 or 30 extra posts mentioned are needed to simply figure out that the OP is talking about a Combobox, not a Drop Down Box (which most of us get immediately) nor an Option Box (which is something else, altogether) nor a DDL (which apparently stood for Drop Down Line!)
Also, obne site every Access developer should have bookmarked is Allen Browne's site:
http://allenbrowne.com/tips.html
This is not a 'learning' site, per se, but has dozens of specific answers to common questions.
Linq ;0)>
Also, obne site every Access developer should have bookmarked is Allen Browne's site:
http://allenbrowne.com/tips.html
This is not a 'learning' site, per se, but has dozens of specific answers to common questions.
Linq ;0)>
Similar threads
