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?'
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?'