View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thorsten Walenzyk Thorsten Walenzyk is offline
external usenet poster
 
Posts: 10
Default "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