Quick and simple question on ListBox control

[xrb08162]

Hi,

This should be simple but my lack of experience is hindering me.

I wish to add a list box control to a spreadsheet with two option in the drop down list. When one option from the drop down list is selected, I want it to enter a certain number into a cell, but when the other option is selected, a different number is entered into the same cell.

For example, if the two options are "Green" and "Blue", if Green is selected the value in cell C3 will be 5, but if Blue is selected, the value in C3 will be changed to 10.

I can do this with option buttons but I'd rather have a drop down list.

Many thanks

 

[bobsan42]

is it a listbox or a combobox?

sub listbox_AfterUpdate ()
if listbox.value="Green" then
range("C3").value = 5
else
range("C3").value = 10
End if
End Sub

the more simple way is to link the box to a cell (Properties->LinkedCell-> C4 for example)
so when you change the listbox it will change the cell C4
then put the formula in C3
=if (C4="Green", 5, 10)