View Full Version : Can't Scroll Down Dropdown List
JLandrum
05-18-2015, 01:42 PM
Can anyone help me, I made a drop down box for items. The box contains items but I cannot scroll down the populated list. Thanks for the help
Yongle
05-18-2015, 02:29 PM
13433
Create named range MyList for your list of items
Then when in relevant cell click on data validation, select allow "LIST" and then in "Source" enter formula =MyList
(or attached workbook , go to cell F6, click on data validation, also click on Formula tab/Name Manager)
JLandrum, we like to have all problems be searchable for every one. "Hejp" is not a very good search term, so I am changing your thread title to make it more search friendly. I do hope you don't mind.
SamT
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.