1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automating input and validating

Discussion in 'VBA Macros' started by Kurt Smart, Apr 16, 2018 at 12:05 AM.

  1. Kurt Smart

    Kurt Smart New Member

    Messages:
    20
    Hi everyone,

    I have little experience with VBA, could anyone come up with a solution or guide me on the path to achieve the below...

    Enter number in H2...
    Check if it exists in 'Completed' or on 'In Progress' tabs...
    If it does input zeros in I2, J2, K2 & L2...
    If it doesn't exist then only allow inputs higher than zero in same cells above.

    I'm trying to stop people from inputting say in I2 a number 45 then in J2 20 and then zeros in the other two, I want data higher than zero in all 4 of those cells, only if that number in H2 doesn't already exist (duplicate).

    Thank you for any help or/and solutions
  2. Logit

    Logit Active Member

    Messages:
    164
    Will the user enter data in the order you've posted ?
    H2 then I2, then J2, then K2, Then L2 ?

    Will there ever be a circumstance where they will not adhere to that order ?
  3. Kurt Smart

    Kurt Smart New Member

    Messages:
    20
    Hi, generally it is random, the information is inputted based on how they get it on paper to transfer, eventually I'd like a pop-up box that forces order.
  4. Logit

    Logit Active Member

    Messages:
    164
    Please post a copy of your workbook, absent any confidential data.
  5. Kurt Smart

    Kurt Smart New Member

    Messages:
    20
  6. Logit

    Logit Active Member

    Messages:
    164
    Sorry .. the link does not provide any download.

    ???
  7. Kurt Smart

    Kurt Smart New Member

    Messages:
    20
  8. Logit

    Logit Active Member

    Messages:
    164
    Which sheet tab is the user entering in H2 ?
  9. Kurt Smart

    Kurt Smart New Member

    Messages:
    20
    In Progress.... Sorry yes forgot the important detail there

Share This Page