+ Reply to Thread
Results 1 to 3 of 3

If cell is empty and macro is pressed display error message.

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    1

    Post If cell is empty and macro is pressed display error message.

    Hi I've got the macro code here and I can't figure out how to do that, if the macro is pressed and cell D2 and cell A12 is empty there will be error message like "please fill in the invoice" and if those cells are filled in the macro will run.
    Please can you help me.

  2. #2
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: If cell is empty and macro is pressed display error message.

    I'm new here but i think you might want to go read the forum rules located @

    http://www.excelforum.com/forum-rule...rum-rules.html

    I believe the people who will be able to help you will want the file and or code your are using that gives you that error.

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: If cell is empty and macro is pressed display error message.

    You can try this... it should show a message box with the error if EITHER cell is blank. But since we don't have your code, it's tough to be sure...

    Please Login or Register  to view this content.
    Last edited by Moo the Dog; 12-20-2012 at 02:01 PM. Reason: Forgot to add CODE tags.. my bad :)

+ Reply to Thread

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