Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing only blank or cell with "X" in it?
Users, we are a frustrating lot, eh?! <g I'm having to deal with
useres myself after being called back to a great place to work that I'd left after that first contract's end last summer. The Excel file I'd created then for my own use and that of my supervisor only is now shared with an additional 6 people! Boy, the trouble they get into! <g They're messing up one of my reports because the cell that should only be blank or have an "X" in it for completed, as per the pulldown boxes!, has comments in it that should go in an adjacent cell. Since we now have several hundred entries hadn't noticed this till now. Is there a way to restrict input to either a blank cell or the "X"? It would be too limiting to not have the blank cell in the value list for the data validation field because once you've selected that "X", watch out, you can't then take the X off to change the state to still pending. That's the only way I know to restrict the data and it's too much restriction. Is there a way to do this? Tx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing only blank or cell with "X" in it?
Data validation does not restrict you from deleteing the value in the cell.
So I don't know how it can be too restricting if the cell can only be blank or have an X. Perhaps you are trying to clear the cell with the spacebar - use the delete key. -- Regards, Tom Ogilvy "StargateFan" wrote in message ... Users, we are a frustrating lot, eh?! <g I'm having to deal with useres myself after being called back to a great place to work that I'd left after that first contract's end last summer. The Excel file I'd created then for my own use and that of my supervisor only is now shared with an additional 6 people! Boy, the trouble they get into! <g They're messing up one of my reports because the cell that should only be blank or have an "X" in it for completed, as per the pulldown boxes!, has comments in it that should go in an adjacent cell. Since we now have several hundred entries hadn't noticed this till now. Is there a way to restrict input to either a blank cell or the "X"? It would be too limiting to not have the blank cell in the value list for the data validation field because once you've selected that "X", watch out, you can't then take the X off to change the state to still pending. That's the only way I know to restrict the data and it's too much restriction. Is there a way to do this? Tx. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing only blank or cell with "X" in it?
On Fri, 6 May 2005 08:20:21 -0400, "Tom Ogilvy"
wrote: Data validation does not restrict you from deleteing the value in the cell. So I don't know how it can be too restricting if the cell can only be blank or have an X. Well, in Excel 2000 if I didn't have that extra blank cell, if one chose the X because it represents that a file is close, it the file became active for any reason and one needed to show this by taking the X out, too late. You couldn't go back to change it to a blank cell again (without being someone like me who knows how to go behind-the-scenes, as it were). Perhaps you are trying to clear the cell with the spacebar - use the delete key. Ah, I'm not sure. I'll have to try this again, then, to test this exact behaviour. I've never been able to do this, but maybe what you describe is where the problem lies. Tx. -- Regards, Tom Ogilvy "StargateFan" wrote in message .. . Users, we are a frustrating lot, eh?! <g I'm having to deal with useres myself after being called back to a great place to work that I'd left after that first contract's end last summer. The Excel file I'd created then for my own use and that of my supervisor only is now shared with an additional 6 people! Boy, the trouble they get into! <g They're messing up one of my reports because the cell that should only be blank or have an "X" in it for completed, as per the pulldown boxes!, has comments in it that should go in an adjacent cell. Since we now have several hundred entries hadn't noticed this till now. Is there a way to restrict input to either a blank cell or the "X"? It would be too limiting to not have the blank cell in the value list for the data validation field because once you've selected that "X", watch out, you can't then take the X off to change the state to still pending. That's the only way I know to restrict the data and it's too much restriction. Is there a way to do this? Tx. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing only blank or cell with "X" in it?
On Fri, 06 May 2005 21:25:49 -0400, StargateFan
wrote: On Fri, 6 May 2005 08:20:21 -0400, "Tom Ogilvy" wrote: Data validation does not restrict you from deleteing the value in the cell. So I don't know how it can be too restricting if the cell can only be blank or have an X. Well, in Excel 2000 if I didn't have that extra blank cell, if one chose the X because it represents that a file is close, it the file became active for any reason and one needed to show this by taking the X out, too late. You couldn't go back to change it to a blank cell again (without being someone like me who knows how to go behind-the-scenes, as it were). Perhaps you are trying to clear the cell with the spacebar - use the delete key. Ah, I'm not sure. I'll have to try this again, then, to test this exact behaviour. I've never been able to do this, but maybe what you describe is where the problem lies. Tx. [snip] This is too funny for words. That must be what I always do without thinking. Oh, I think I know where this false idea came from. I think that unlike the case now, I needed to have the X as one of the possible entries but left the blank cell for complete flexibility. That must be it; but I somehow got mixed up in my mind that that's the only way to be able to have a blank cell <g. Funny. This ng keeps me humble, let me tell you! <lol Thanks. In this one case, the cell can only be blank or have an X and my users are making my life so much fun that I'm going to impose it on them! No more false reporting, pls, for all our closed dockets! <g Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |