Well, Data Validation is probably the simplest way to do that. But you could also drop a Combo Box on the worksheet using the Control Toolbox toolbar. You would need to set a few properties for it to work the way you want. In particular, look at ListFillRange and LinkedCell.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.