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
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
