![]() ![]() Hp officejet pro 8710 driver and software. The search I did was: With thanks, Jonathan. I might be wrong, and I am about to test some of the solutions provided. From past experience, I recall VBA solutions will not work on Mac. What I'd like to know is if there is any way to convert the validation list into some kind of complete-as-you-type drop-down list? I am using Excel 2011 (v14.3.4) on Mac OS X 10.8.5 I did find many discussions about this functionality, but as far as I can tell the answers all related to using VBA on Excel for Windows. With many thousands of entries, it is very tedious to search through the list for each entry. What I was mistakenly anticipating is that as I start typing 'av' (for example) the list will drill down to the 'AVL - Another One' entry. Let's say we the following have: AB1 - The Place AC2 - Something else AVL - Another one In a cell I have that list set as a Validation list. What I was expecting is that when I set up those lists as validation lists for cell input, I would be able to just start typing and the list would move to any valid entries. I have lists with in excess of 10,000 entries. So I am hoping an Excel pro can prove otherwise. To stop people from entering data that isn’t in the drop-down list, click Stop.Īnd yet I find that hard to believe. Information will show a message with this icon and Warning will show a message with this icon. To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click Information or Warning. ![]() I found nothing, so I am thinking it's not possible. Hi folks, I've looked high and low for a solution to this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |