| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking up a table value based on two conditional option buttons
I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the contract volume (row) and the contract length (column). My sales reps input the contract volume and length by selecting OptionButtons in another worksheet within this workbook. Can I code a macro to take the selections from those two OptionButtons, select the corresponding percentage, and output it for use in my pricing equation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| How do I select a value from a table based on 2 conditional refs? | Excel Worksheet Functions | |||
| Option buttons: How to get the selected option from a group? | Excel Programming | |||
| Navigating between option buttons is not selecting the option | Excel Programming | |||
| Navigating between option buttons is not selecting the option | Excel Programming | |||
Threaded Mode
