Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |