You can try this. It might need some tweaking, but this is
the general gist of it.

"teepee" wrote:


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