+ Reply to Thread
Results 1 to 3 of 3

Macro that detects if specific cells are blank, does a pop up

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Cool Macro that detects if specific cells are blank, does a pop up

    Hello,

    I want to develop a macro that detects if one or both specific cells on a sheet are blank, and then creates a popup window if this is the case. The pop up can just say "stop, and fill in the blanks" and the with a okay button.

    I will have other macros set to run after this that are already built. Should the above macro not get activated by the blank cells I want it to proceed to the next macros. If the pop up is triggered, in want the rest of the process to terminate, and not proceed to the next macros.

    Thanks!

    Lora

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro that detects if specific cells are blank, does a pop up

    you could just do a pre-check before your main macro

    Please Login or Register  to view this content.
    if you want something more "custom" like a pop up you can fill in then you can use a modeless userform i guess
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    12-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Macro that detects if specific cells are blank, does a pop up

    Thank you for your help - I actually used something very similar that worked out. I used the following:

    If Range("A1,A4") = "" Then
    MsgBox "Fill in all cells"
    Exit Sub
    End If
    'rest of code

+ 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. [SOLVED] Macro that detects numbers out of sequence, then inserts a new row and adds the missing
    By Lmel0611 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2015, 11:11 PM
  2. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  3. [SOLVED] Macro that detects certain value and replaces value
    By keis386 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-28-2013, 11:54 AM
  4. How can I make a macro ignore blank cells? - Blank Cells have formulas
    By mz1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:54 AM
  5. Macro to copy rows if detects a specfic key word
    By Misbah211 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2012, 10:38 AM
  6. Macro that detects the source files and lists all the formulas
    By triplemints in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2010, 07:48 PM
  7. Create a macro to blank cells in a specific workbook - Excel 2003
    By Elmer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2008, 07:16 PM

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