"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

"Pick from list"
 

Thorsten,

You should, instead, discover Data Validation, which is basically what
you've described. You can either change the cell's data validation through
code, or use code to validate the entry, perhaps by using the worksheet
change event. Lots of examples in the archives.

HTH,
Bernie
MS Excel MVP

"Thorsten Walenzyk" wrote in message
...
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