Solved - Quick Lookup Question

[WorkMC]

I've a Userform with two combo boxes on. Depending on the values selected from these two boxes I would like a lookup result to show in a text box. Is this possible and if so how?

I've looked at various posts but do not seem to be able to find what I'm after.

Thanks in advance.

 

[Smitty]

So you want to lookup your concatenated textbox entries from a worksheet list?

Take a look at the "Find method" in the VBA helpfile. You can use TB2's Exit event to invoke the lookup and return the result to TB3.

I think that might do what you want.

Hope that helps,

Smitty