Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Userform combobox question
Hello I have a userform combobox which is linked to the values in column A I want to find a way in VBA so that when an item is selected from the drop down menu, it returns the value generated by the formula in the adjacent cell in column B So in example below, if I select joe, I want the value 45 put somewhere I can use it as the input for the next vba variable. john 25 joe 45 carol 65 Anyone got any ideas? Many thanks TP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format combobox in userform to accept dates | Excel Worksheet Functions | |||
combobox Question | Excel Discussion (Misc queries) | |||
Userform w/ComboBox | Excel Discussion (Misc queries) | |||
Getting combobox dropdowns to appear on a userform when tabbed to. | Excel Discussion (Misc queries) | |||
UserForm TextBox/ComboBox question | Excel Discussion (Misc queries) |