Results 1 to 3 of 3

Pop-Up Message if Cell not completed

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003 and Excel 2007, Excel 2011 (Mac)
    Posts
    1

    Pop-Up Message if Cell not completed

    Hi,

    I need to add a pop-up message (which stops a macro running), when certain cells are not completed - in EXCEL 2003.

    All the cells are validation drop-downs so I can add a message if the wrong thing is entered but not if it's not been updated at all.

    The trigger for the message should be when a macro is run to warn the user that the spreadsheet is not complete.

    Does anyone know how to do this?

    The code in the macro is currently:
    '
       ActiveSheet.Unprotect
        Sheets("Data Sets").Visible = True
        Sheets("Data for CS").Select
        Columns("B:E").Select
        Selection.Delete Shift:=xlToLeft
        Sheets("Data Sets").Select
        Selection.AutoFilter Field:=5, Criteria1:="TRUE"
        Range("B2:E32").Select
        Selection.Copy
        Sheets("Data for CS").Select
        Range("B2").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
            SkipBlanks:=False, Transpose:=False
        Columns("B:E").Select
        Columns("B:E").EntireColumn.AutoFit
        Sheets("Data Sets").Select
        Selection.AutoFilter Field:=5
        Application.CutCopyMode = False
        ActiveWindow.SelectedSheets.Visible = False
        Range("B2:E32").Select
        Sheets("Input").Select
        ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
        Sheets("Data for CS").Select
    End Sub
    Many Thanks!

    Richard
    Last edited by davesexcel; 12-14-2012 at 05:42 AM. Reason: Code tags required, please read the forum rules

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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