Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rick, first off, Thank you for your patience with me!
And, thank you for the advice - I will try to track the book down that you mention to carry me over the summer. I too am a strong believer that you only need to know something exists to be able to use it in future - how to do it comes when you use it, and if you use it enough it will eventually sink in :) I have completed an on-line course, however without a paper reference I found it very frustrating trying to go back through the videos (chapters) to find the info again to reference it, even though I thought I had taken very good notes. Between the two other books I've purchased and read, and then this user group (both current and historical info) and of course the websites you folks refer to here I think what I did was bombard myself with too much info and not able to index it in my little mind. I believe a structured course will help to align things for me and then maybe I will be able to use it! I will say, I've had a blast with this little project I've worked on, and really look forward to torturing myself again in the very near future! Thanks for all your help! Janice "Rick Rothstein (MVP - VB)" wrote: From my understanding, a user can actually add more items to the list using a ComboBox. Are you going to tell me I'm wrong and there was a whole lot easier way to go about this ?!?!?! Sorry, but you are wrong. See Chip's posting for more details on this. (Trust me, I will be taking a course in the fall to fully understand this) Taking a course is a great idea... it will give you a structured introduction and overview that will provide you with a foundation on which you can build. One key piece of advice that I give to newcomers in VB... read the documentation... read the help files on each function, statement and control (along with its properties) available to you in VB(A). Now, I am not suggesting that you memorize them all (heaven forbid, I have only a small percentage of them memorized myself); rather, I am suggesting that you learn they are there and roughly what they are capable of doing. If you know they exist, and you know what they can do, you can think in terms of them when you do your coding. You don't have to know the syntax cold (the help files or VB's Intellisense can fill those in for you); all you are trying to do is KNOW what is available to you as a VBA programmer, nothing more. Hell, I even found a use for the Partition statement once and I was only able to do that because I knew it existed and roughly what it did. I can hear the majority of people following this thread going: "The Partition statement, what the hell is that?!!?" It is not really a very useful command (but, as I said, I did find a use for it once) and I would be willing to bet 99.9% of the VB programmers (both for VBA and compiled VB) don't even know it exists. Anyway, that is my one piece of wisdom concerning programming... take it or leave it. There is a decent reference book out there (it may be hard to find with all the VB.NET stuff eating up the bookstore space) that you may want to consider picking up. It is called "VB & VBA in a Nutshell" by Paul Lomax Published by O'Reilly ISBN No. 1-56592-358-8 Best would be if you could check it out in a local bookstore to see it the layout and style is to your liking. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Data Validation (Listbox) | Excel Worksheet Functions | |||
Finding window handle of data validation listbox | Excel Programming | |||
Userform: listbox and controls' data entry validation | Excel Programming | |||
Data Validation Listbox problem | Excel Programming | |||
Change event for data validation listbox | Excel Programming |