+ Reply to Thread
Results 1 to 7 of 7

How do I display an error message if Find Macro is unsuccessful

  1. 10-29-2008, 06:40 PM #1
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    How do I display an error message if Find Macro is unsuccessful

    The code below searches the entire sheet for an email address that the use has inputted into cell E3. How can I make this code show an error message if there are no matches found?


    Please Login or Register  to view this content.

    Thanks!
    Clayton Grove
    Reply With QuoteRegister To Reply
  2. 10-29-2008, 06:44 PM #2
    Tirren is offline
    Registered User
    Join Date
    07-02-2008
    Location
    Fort Worth, TX
    Posts
    99
    Please Login or Register  to view this content.
    Use above and modify to your hearts content.

    Bob's is better as it does more of what you want.
    Last edited by Tirren; 10-29-2008 at 06:49 PM. Reason: Better answer provided.
    Reply With QuoteRegister To Reply
  3. 10-29-2008, 06:46 PM #3
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 10-29-2008, 06:52 PM #4
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324
    Hmm, its not working. I could have done something wrong, but when I put random text in cell e3 and run the macro, I do not get an error.
    Reply With QuoteRegister To Reply
  5. 10-29-2008, 06:56 PM #5
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Maybe ...
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  6. 10-29-2008, 07:00 PM #6
    dcgrove is offline
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324
    Apparently I am rather dense as I have tried all three and none of them display an error message if there is any text in cell E3 if it is blank, they all work dandy. I have even removed all of the address from the sheet to test it out so I know it is not finding something. I am at a loss now.
    Reply With QuoteRegister To Reply
  7. 10-29-2008, 07:25 PM #7
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Sorry. Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1