Update after selection

[BSando]

Hi

I'm sure this is simple but I just can't get me head around it.

I have a combobox on a spreadsheet which is linked to a cell (B9) and when the user selects the item from the list I want to update cells on the same sheet based on a table.

I can update the cells with the below code:

Sheets("sheet1").Range("B10").Value_
= Application.VLookup(Sheets("sheet1").Range("B9"),_ Worksheets("sheet4").Range("A2:G200"), 2, False)

But I just can't work out how to update the cells on making the selection in the combobox

Any help is much appreicated.

Thank you in advance

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[SkipVought]

Hi,

Please explain what you are trying to update with the combo selection.

Is it ALWAYS the same cell?

Are you adding rows to a table?

Where is the table and what is the structure?

Please be clear, concise and compete.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[BSando]

Skip

I found a work around. I just validated a cell instead of using the combobox and used Vlookup for the other cells that needs updating

Thanks anyway

Some people make things happen, some watch while things happen, and some wonder 'What happened?'