Linking combobox to optionbutton?

DUGG · Mar 2nd, 2002, 07:37 PM

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 · Mar 3rd, 2002, 02:18 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 07:37 PM	#1
DUGG New Member Join Date: Mar 2002 Posts: 2	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!

Mar 3rd, 2002, 02:18 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.