control box
 

In an active X control box - is there any way to only allow the list that its
linked to. meaning I linked to a range - but you can still type in whatever
you want - can I stop this ?
Thanks,
Yosef

Yes, change the Style property to 2 - fmStyleDropDownList

--
Regards,

Juan Pablo González
Excel MVP

"ynissel" wrote in message
...
In an active X control box - is there any way to only allow the list that
its
linked to. meaning I linked to a range - but you can still type in
whatever
you want - can I stop this ?
Thanks,
Yosef