View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neon520 Neon520 is offline
external usenet poster
 
Posts: 129
Default 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!!!!