combo Box programming

[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

 

[Bob Phillips]

Brett,

Do you have a table of data where the values in the combobox is the first
column? Assuming so, and it has a name of say 'myTable', you can use VLOOKUP
in VBA to get the data

Set rng = Worksheets("Sheet1").Range("A1")
With Combobox1
rng.Value = .Value
rng.Offset(0,1).Value = Application.VLOOKUP(.Value,
Range("myTable"),2,FALSE)
rng.Offset(0,2).Value = Application.VLOOKUP(.Value,
Range("myTable"),2,FALSE)
End With

Add this code into the combobox click event.