+ Reply to Thread
Results 1 to 2 of 2

Entering text into a cell that contains a drop down with restricted values

  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Entering text into a cell that contains a drop down with restricted values

    I am creating an electronic timesheet that contains cells in which the time of day is entered. Sometimes, it is necessary to enter text into this cell via a drop down box that includes such options as "Vacation" or "Sick Time". When I now try to type in the dime of day (e.g. 17:00), it gives me an error stating "The value you have entered is not valid. A user has restricted values that can be entered into this cell." How do I allow a cell to have a drop down with a few selectable items while still allowing the times to be manually typed in?
    Last edited by jonvanwyk; 08-03-2010 at 06:26 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Entering text into a cell that contains a drop down with restricted values

    change the error alert to warning instead of stop
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1