 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / January 2008Data 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!!!! 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 > 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. [quoted text clipped - 7 lines] > > Any idea? Really strange!!!! 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??? > 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 [quoted text clipped - 14 lines] > > > > Any idea? Really strange!!!! 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 > I tried resetting it several times, but the weirdest thing is the list WORK > on a new worksheet I open to tried it out!!! [quoted text clipped - 18 lines] > > > > > > Any idea? Really strange!!!! THANKS A LOT, EVERYONE!!! THIS HAS BEEN REALLY HELPFUL!!!!! > 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 [quoted text clipped - 25 lines] > > > > > > > > Any idea? Really strange!!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.