"Pick from list"

  • Thread starter Thread starter Thorsten Walenzyk
  • Start date Start date
T

Thorsten Walenzyk

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
 
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
 
You must log in or register to reply here.

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

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
pick from list 2
List 1
pick from list 5
Data Validation List (conditional) 2
Colour-coding a cell from a drop down list 1
Table with two pick from list columns that need to vlookup each ot 1
Copying List box values/selection to a database of sorts 2

Back
Top