Linking combobox to optionbutton?

[DUGG]

Im trying to link a combobox, that has drop down choices of wood types, so that the price from a vlookup funtion goes to the link cell selected from choosing an option button. So basically im trying to get the combo box to link to a different cell each time. Any ideas would be great thanks!

 

[Dave Hawley]

Hi Dugg

I have an example of how this can be done here: http://www.ozgrid.com/download/default.htm under: ChangingCombo.zip

It uses a ComboBox and OptionButtons from the Forms toolbar, so no VBA is needed.