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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Linking combobox to optionbutton?
- Thread starter DUGG
- Start date
Excel Facts
Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Dave Hawley
Rest in Peace
- Joined
- Feb 28, 2002
- Messages
- 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.
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.
Upvote
0
Similar threads
- Replies
- 2
- Views
- 685
- Replies
- 2
- Views
- 244
- Replies
- 4
- Views
- 81
- Replies
- 3
- Views
- 527
