exceldvlpr
New Member
- Joined
- May 22, 2002
- Messages
- 20
I have a list of names in combobox2, (Input Range is B4:B18, linked cell is H7), that are linked to what ever is chosen in combobox1 (Input Range F4:F8, linked cell is H6) I need a formula that will reference the name that is currently selected in combobox2.
Is there a way to return the value of what's currently displayed in a combobox aside from referencing the input range? I can't figure out a different way to do this because what ever you choose in combobox1 changes what's in combobox2.
Thanks for the help.
Is there a way to return the value of what's currently displayed in a combobox aside from referencing the input range? I can't figure out a different way to do this because what ever you choose in combobox1 changes what's in combobox2.
Thanks for the help.