Combo box problems

B

brett4098

I have a Combo box list populated. What i am trying to achieve is when
select a name from the list, i can have information about that nam
populate a part of the spreadsheet. When i select a different name, i'
like the old info to disappear and the information for the next nam
appear. Any help would be much appreciated. Thanks guys, you've bee
great in the past
 
A

AlfD

Hi!

Try putting a Textbox control on the sheet and aim to show your chose
text there in the form of the textbox's text.
Try a small experiment:
Add the textbox and amend its Properties so that Linked Cell ia A1.
Enter a message in A1: read it in the box.

Whatever you get from the combobox input will enable you to do
vlookup in A1 using a vertical lookup table with your combobox items i
one column and your text messages in the next.

Schematically: put =Vlookup(<combobox value>, <lookup table, 2,False
in A1.

You might also think of combining the combobox listfill rangewith th
identical thing in the lookup table.

Al
 
Top