Auto-complete for multi-valued cells?

F

felciano

Hi --

I'm trying to build a spreadsheet that allows users to enter a comma-
delimited list of values in specific cells, sort of like a list of
tags in delicious etc. The values should be from a restricted list.
For example, if the restriction is a list of names of fruit, it would
allow users to enter "apple, banana, pear" into a cell.

To help users enter the correct values, I would like to show an auto-
completion menu while they type. Excel's autocomplete works for a
single value match -- in the above example, it would match "apple".
But once you've 'accepted' the first value by typing a comma, it will
no longer match as you start typing the first few characters of the
next value (banana).

Is there a way to subvert the built-in functionality to match
individually in a comma-delimited list? And if not, is there a way to
reproduce this functionality from within VBA (e.g. trap key-presses
and do the completion match yourself)?

Thanks!

Ramon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top