Set ComboBox (ActiveX Control) value to cell

**farzyness** · 01-11-2011, 01:04 PM

Hi all,

Very simple procedure, but I'm not familiar with the syntax. All I want to do is set the present ComboBox value to a cell on the spreadsheet. I'm trying to execute a vlookup automatically so that whenever the ComboBox is changed, a TextBox can display the result from the vlookup function, and I want this to be done automatically.

But in essence, setting the value of the ComboBox is the first thing I'd like to do.

Thank you very much!

**ker9** · 01-11-2011, 01:24 PM

Do you want the combo box value to change to the cell on the spreadsheet - or do you want the cell to change to the value of the combo box?

If it is the latter, the simplest method is to view the properties of the combo box and change the value of the Linked Cell property to the cell you want to display the value of the combo box.