Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default ListBox data validation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Data Validation (Listbox) NoodNutt Excel Worksheet Functions 6 March 8th 08 12:35 PM
Finding window handle of data validation listbox PastorMike[_2_] Excel Programming 2 August 18th 06 07:03 PM
Userform: listbox and controls' data entry validation sebastienm Excel Programming 2 September 15th 05 02:02 PM
Data Validation Listbox problem RASEnt Excel Programming 0 June 12th 05 11:47 PM
Change event for data validation listbox Steve Parkinson Excel Programming 4 January 14th 05 02:57 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"