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