Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick list and Data Validation
Hi,
Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick list and Data Validation
Hi,
Take a look at Debra webpage http://www.contextures.com/xlDataVal02.html#TwoWord "Makelei" wrote: Hi, Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick list and Data Validation
Thanks Eduardo,
I have used these featurea often and are working just fine. My problem is that someone has started to update the table with mouse right click using "Pick From Drop-down List". Now when this is used it will disable visibility of data validation feature. Actually you are able to define it, but when cell is activated, arrow and list will not be visible. This is the very first time I have come agross this and do not know how to return back and get this data validation to work as it should. BR Makelei "Eduardo" wrote: Hi, Take a look at Debra webpage http://www.contextures.com/xlDataVal02.html#TwoWord "Makelei" wrote: Hi, Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data-Validation -List - Pick from a drop down menu | Excel Discussion (Misc queries) | |||
using excel to pick data from a list, reporting names and integers | Excel Discussion (Misc queries) | |||
Extract data value using pick list | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) |