| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric Value of Choice in Combobox
Once an item is chosen from a combobox, how do I determine the corresponding
numeric value of that choice? I need that value in order to pull in another value from the spreadsheet. Thanks, Les |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric Value of Choice in Combobox
"WLMPilot" skrev i en meddelelse ... Once an item is chosen from a combobox, how do I determine the corresponding numeric value of that choice? I need that value in order to pull in another value from the spreadsheet. Thanks, Les Hi Les Private Sub ComboBox1_Change() choice = Me.ComboBox1.ListIndex End Sub Just remember that first item will be equal to index = 0 Regards, Per |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numeric Value of Choice in Combobox
Thanks! One more quick question. Do the textboxes, comboboxes, etc have to
be DIM or is it automatic? Thanks, Les "Per Jessen" wrote: "WLMPilot" skrev i en meddelelse ... Once an item is chosen from a combobox, how do I determine the corresponding numeric value of that choice? I need that value in order to pull in another value from the spreadsheet. Thanks, Les Hi Les Private Sub ComboBox1_Change() choice = Me.ComboBox1.ListIndex End Sub Just remember that first item will be equal to index = 0 Regards, Per |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a RowSource Depending on ComboBox Choice | Excel Discussion (Misc queries) | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| combobox loses first choice | Excel Programming | |||
Hybrid Mode
