+ Reply to Thread
Results 1 to 4 of 4

If drop down input selected as "No" can you force input to another cell?

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    England
    MS-Off Ver
    2013
    Posts
    3

    Question If drop down input selected as "No" can you force input to another cell?

    Good afternoon all,

    So I have another query....

    Is it possible to force input in another cell if a certain condition is selected?

    I have a cell where data validation from a list only allows Input of Yes Or No. If the criteria of No is selected is it possible to force the user to input data in to another cell?

    The theory behind it is, the column asks if something is working, if the user selects No I am trying to make them record the Log number they received from the maintenance team when they report the broken item.

    Is this possible, if so how?

    Any help would be greatly appreciated.

    Kind regards,

    Y.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,797

    Re: If drop down input selected as "No" can you force input to another cell?

    It is possible but forcing user input requires macros. It would help to have your file, but without it I can describe the general approach.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    03-26-2020
    Location
    England
    MS-Off Ver
    2013
    Posts
    3

    Thumbs up Re: If drop down input selected as "No" can you force input to another cell?

    Morning.

    Thanks for the response.

    I have attached a sanitised copy of the worksheet I am using with some dummy data, however the format etc is the same. I hope this helps.

    In essence if Coulumn D and Column J are selected as No I am trying to force input to column E / K for the respective row.

    I hope that makes sense.....
    Attached Files Attached Files

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,797

    Re: If drop down input selected as "No" can you force input to another cell?

    Here is a VBA solution that won't let the user do anything if they select No without entering a log number.

    You were missing the Yes/No in column Z so I put that in.

    If the user selects No, it immediately prompts to fill in the log number, and it won't let you go anywhere else until you do, except to change the No back to Yes.
    Attached Files Attached Files

+ 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