I have a a couple lists of data that I want in a drop-down but despite setting the Error Alert to Stop and checking the Show error alert after invalid data is entered, the cell is still enabling any values to be entered.
This is something I have encountered previously and I can't remember how I fixed it but I would have thought this shouldn't happen....?
TIA
If you are allowing any value as the subject suggests then there is nothing to disallow?
What have you picked for the 'Allow' box?
I suggest you upload the workbook so that we can see in context.
Last edited by Richard Buttrey; 05-26-2016 at 10:37 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
OK, I managed to establish what was happening and its a seems to be a little strange.
I am using the drop-down for a dynamic list of data.
The list of data starts in cell A3 and can be any number of items long.
Cell A2 has a range name of DataStart (I use the cell directly above the start of the data for the label in case anyone deletes the data by deleting the rows rather than hitting delete and when the headers are protected, this ensures the range name isn't lost).
Cell A1 has a count of of the items in the list starting at A3 down to A500 and this cell has a name range of DataCount. So if there are 75 items in the list then my count returns 75.
Cell C1 has the following formula where you can specify the range of data for the drop-down to create a dynamic list =OFFSET(DataStart,1,0,DataCount). All the relevant check boxes to stop invalid entries are checked but this still allows an invalid entry.
Now if I change the DataStart named range to cell A3 and the Offset formula to =OFFSET(DataStart,0,0,DataCount), this works and stops invalid entries.
Both options effectively do the same thing but the first one doesn't do as it's told!
Is this a bug in Excel that needs reporting?
Hi,
As I said, upload the workbook so that we can see the problem of which you speak in context.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks