Results 1 to 6 of 6

Repeat Message box routine with IF condition and condnl formatting

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Repeat Message box routine with IF condition and condnl formatting

    Hi all,

    I have a sample sheet which explains everything.

    Two issues:
    I want message box routine to repeat until valid value from range 'Reason' or 'NA' is entered.
    Basic code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If ThisWorkbook.Sheets(1).Range("G26").Value = "1" Then
    MsgBox " Input Reasons for Delay. If On Time, Please enter 'NA'."
    'need help here to add - repeat messagebox routine until valid text from Range "Reason" and "NA" is entered
    End If
    End Sub
    Second issue
    If value in G26 is equal to 1, then cell C27 must get drop down menu options from Range 'Reason' and if value is zero then it simply indicates NA

    Any help please
    Kind regards
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run routine on entering a txt box with condition/if statement
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2013, 08:30 AM
  2. Slight modification to formatting sub-routine
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2013, 07:06 PM
  3. Slight modification to formatting sub-routine
    By pglufkin in forum Excel General
    Replies: 0
    Last Post: 11-07-2013, 02:44 PM
  4. Macro for repeat functions with if condition
    By mkanagaraj in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-23-2012, 02:08 AM
  5. Sum until a condition is met and repeat for a range
    By natattack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2012, 06:30 PM

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