Don't want cells left blank when using Data validation
Don't want cells left blank when using Data validation
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Don't want cells left blank when using Data validation

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Don't want cells left blank when using Data validation

     
    I am using Data Validation and I don't want the user to go past a cell without putting in an entry. When I leave the box (ignore blank) unchecked it doesn't do anything after I have protected the document.

    Help

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's your validation criteria?

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    St. Louis
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Validation

    The only way I could accomplish what you are attempting is by: 1) Using a drop down list; 2) unchecking "lignore blank"; 3) choose any value form the list; 4) and last, protect the sheet.

    Dexter

  4. #4
    New Member
    Join Date
    Jan 2003
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The user can add anything they want--- the cell just can't be left blank so a drop down list won't work

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not set "Text length not equal to 0" and uncheck "Ignore blanks"?

  6. #6
    New Member
    Join Date
    Jan 2003
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that and it still lets the user to tab past that cell to the next cell that needs information anyother ideas

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Data Validation only governs the Edit process. If you don't edit the cell Data Validation has no impact.

  8. #8
    New Member
    Join Date
    Jan 2003
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So is there a way that I can get the user to input something before moving to the next cell?

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I suppose the event could be enforced by a VBA macro.

  10. #10
    New Member
    Join Date
    Jan 2003
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Is there no other way I really don't like macros

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com