+ Reply to Thread
Results 1 to 2 of 2

Code to ask question then compare that answer to cell on sheet then continue

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Code to ask question then compare that answer to cell on sheet then continue

    I have a sheet "Daily" that in Cell (15, 15) I have a drop down that is either (Yes or No)

    I would like a reply box to ask "Did you Trip due to Motor"
    then I want to compare that answer to that cell (15, 15). If they answer "Yes" but the cell Still has "No" selected in the drop down
    then I need the code to stop running and direct the user back to that cell and Say "You must change your drop down to Yes and rerun macro"

    If their reply matches what the drop down has in that cell then continue running the code.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,068

    Re: Code to ask question then compare that answer to cell on sheet then continue

    Something like
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to stop code,look at a sheet, then continue the code
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2018, 04:10 PM
  2. VBA code to lookup cell in one sheet and compare to second then paste value
    By Zimmerman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2015, 01:11 PM
  3. [SOLVED] Copy Sheet, Open Workbook, Paste and continue with code
    By ksayet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2015, 10:25 PM
  4. code to progressively go throughly question based on answer to first question
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2014, 06:48 AM
  5. [SOLVED] Compare cell in one file to same cell in another file, continue macro only if cells match
    By CherylC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2014, 09:31 PM
  6. if the correct answer is given copy question to different sheet
    By moley165 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2013, 05:01 AM
  7. [SOLVED] changing cell on active sheet does not cause code to continue - No error codes either
    By SoteriaLive in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-01-2012, 11:21 AM

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