| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Fail
Anyone has any idea why I can't validate my data using List.
I tried to set it up both ways: cell reference, and comma split. I worked with the same sheet yesterday, and I could validate the data using List. But when I tried today with a different cell. The drop-down arrow sign show up when that cell is selected, but the list didn't pop up. I did not know how to disable this feature using any VB code, so there is unlikely that there is any code modification... Any idea? Really strange!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Fail
The list does not show up until the arrow is clicked on, not just with the
cell selection. Or maybe some hiccup in the setup.......try going through the procedure again, taking care were you specify the source of the list. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: Anyone has any idea why I can't validate my data using List. I tried to set it up both ways: cell reference, and comma split. I worked with the same sheet yesterday, and I could validate the data using List. But when I tried today with a different cell. The drop-down arrow sign show up when that cell is selected, but the list didn't pop up. I did not know how to disable this feature using any VB code, so there is unlikely that there is any code modification... Any idea? Really strange!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Fail
I tried resetting it several times, but the weirdest thing is the list WORK
on a new worksheet I open to tried it out!!! What could have gone wrong??? "CLR" wrote: The list does not show up until the arrow is clicked on, not just with the cell selection. Or maybe some hiccup in the setup.......try going through the procedure again, taking care were you specify the source of the list. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: Anyone has any idea why I can't validate my data using List. I tried to set it up both ways: cell reference, and comma split. I worked with the same sheet yesterday, and I could validate the data using List. But when I tried today with a different cell. The drop-down arrow sign show up when that cell is selected, but the list didn't pop up. I did not know how to disable this feature using any VB code, so there is unlikely that there is any code modification... Any idea? Really strange!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Fail
Maybe the cell is Validated under some other settings.......try the "Clear
all" button first, and then re-try setting it up......otherwise, it beats me why. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: I tried resetting it several times, but the weirdest thing is the list WORK on a new worksheet I open to tried it out!!! What could have gone wrong??? "CLR" wrote: The list does not show up until the arrow is clicked on, not just with the cell selection. Or maybe some hiccup in the setup.......try going through the procedure again, taking care were you specify the source of the list. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: Anyone has any idea why I can't validate my data using List. I tried to set it up both ways: cell reference, and comma split. I worked with the same sheet yesterday, and I could validate the data using List. But when I tried today with a different cell. The drop-down arrow sign show up when that cell is selected, but the list didn't pop up. I did not know how to disable this feature using any VB code, so there is unlikely that there is any code modification... Any idea? Really strange!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Fail
THANKS A LOT, EVERYONE!!!
THIS HAS BEEN REALLY HELPFUL!!!!! "CLR" wrote: Maybe the cell is Validated under some other settings.......try the "Clear all" button first, and then re-try setting it up......otherwise, it beats me why. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: I tried resetting it several times, but the weirdest thing is the list WORK on a new worksheet I open to tried it out!!! What could have gone wrong??? "CLR" wrote: The list does not show up until the arrow is clicked on, not just with the cell selection. Or maybe some hiccup in the setup.......try going through the procedure again, taking care were you specify the source of the list. Vaya con Dios, Chuck, CABGx3 "Neon520" wrote: Anyone has any idea why I can't validate my data using List. I tried to set it up both ways: cell reference, and comma split. I worked with the same sheet yesterday, and I could validate the data using List. But when I tried today with a different cell. The drop-down arrow sign show up when that cell is selected, but the list didn't pop up. I did not know how to disable this feature using any VB code, so there is unlikely that there is any code modification... Any idea? Really strange!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
