Hi All

Not an area I have explored before so any help appreciated.

I have a range of data in three columns of a worksheet (the data), I have a
userform with a text box control into which the user enters a value
(string).

Another combo box control on the same userform is currently empty. I wish
to use the string entered by the user to search column 1 of the data, if it
is found (and it may find it more than once) the combo box is filled with
the values in the associated second column of the data. If not a message is
displayed.

The user then scans the combobox contents and select the required matching
record. After which a third control on the userfrom shows the value in the
associated third column of the data.

Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---