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
How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
- 109
- Replies
- 2
- Views
- 698
- Replies
- 2
- Views
- 261
- Replies
- 4
- Views
- 111
- Replies
- 3
- Views
- 539
