98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiselect from list in data validation
Multiselect from list in data validation
Resolved · High Priority · Version 2003
Tue 30 Mar 2010, 10:35Delegate Anna said...
Anna has attended:
Excel VBA Advanced course
Multiselect from list in data validation
I'm using data validation - list to allow users to select an option from a pre-defined list. I need to make it possible for them to select more than one option, i.e. when the drop-down list is displayed, they can highlight several options in the list, and then the selection displayed in the cell, separated by commas.
Is this possible and how can it be done?
Thanks
Tue 6 Apr 2010, 14:07Trainer Stephen said...
RE: Multiselect from list in data validation
Hi Anna
Thanks for your question
It does not appear that the combo box \ list validation tools supports multi select. Multi select is a feature released in access 2007 and therefore is fairly new.
I would suggest looking for an alternative strategy for solving your problem. If you can give me a bit more background amybe I could advise further
Regards
Stephen
Tue 13 Apr 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing border lines on the keyboardHighlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines. |
