OK. I've now replied to your earlier post about your VBA vlookup  use not
working, so hopefully you've now got that fixed.

I think what you're saying is that you are trying to type in the name of
a range as the row source property for a control and it's not working,
although you don't say what's happening - are you getting an error
message, do you just get a blank list, or what? If there is a problem
with using the range name, check you have actually defined the name on
the worksheet and that you're spelling it correctly in the properties
table - and that there are no spaces or other punctuation in either
occurance of the name.