"Pick from list"
Hi all,
I just discovered the "Pick from List" function in the context menu for the
cells of a table in Excel.
I'm wonder if I could misuse this feature to allow the user to only select
some given data for a certain cell.
That would require,
1. that I can influence the content of the list. e.g write the selectable
data to the list.
2. I can command Excel to only allow values for that particular cell which
are matching an item in the list
Who knows, if and how this is possible?
Thanks Thorsten
|