Hi
I have a combox on a userform which is linked to a range of cells. Depending on the value they pick, there is some code that does a vlookup on this value. However, I want to be able to restrict the user to only pick one of the items in the combo list. What I'm finding is that if I key in anything else into the combox, the vlookup fails (as you'd expect).
Any ideas?
Thanks
Harv
I have a combox on a userform which is linked to a range of cells. Depending on the value they pick, there is some code that does a vlookup on this value. However, I want to be able to restrict the user to only pick one of the items in the combo list. What I'm finding is that if I key in anything else into the combox, the vlookup fails (as you'd expect).
Any ideas?
Thanks
Harv