Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Would I use "Lookup" to pick names for a Christmas grab bag | Excel Worksheet Functions | |||
"Pick From List . . . " | Excel Discussion (Misc queries) | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
"change" event for validation/pick lists | Excel Programming |