+ Reply to Thread
Results 1 to 4 of 4

Message box pup up when cell contains specific texts

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Australia
    MS-Off Ver
    Mac Office 2011
    Posts
    13

    Message box pup up when cell contains specific texts

    Hi, I'm new for VBA and I believe this is a lamb question. Much appreciate if you could help.

    What I want is when I type ABC or DEF in any cell of column A, it will pup up a message say "Hello"

    Any VBA can do it?

    Thanks

    Vincent

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: Message box pup up when cell contains specific texts

    Hi kleevin,

    Try this event macro on the sheet in question:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    07-09-2012
    Location
    Australia
    MS-Off Ver
    Mac Office 2011
    Posts
    13

    Re: Message box pup up when cell contains specific texts

    Hi Robert,

    It works, thank you very much man.

    Cheers
    Vincent

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: Message box pup up when cell contains specific texts

    You're welcome and thanks for marking the thread as solved

+ 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] VLOOKUP containing specific texts
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2013, 11:48 AM
  2. [SOLVED] IFBLANK formula to output only certain columns and specific texts
    By Isara in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-31-2012, 08:34 PM
  3. Replies: 14
    Last Post: 04-26-2011, 05:25 PM
  4. Copy a specific of data of texts containing "IT"
    By new_to_vba in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2006, 04:00 AM
  5. Summing specific texts
    By LostLady in forum Excel General
    Replies: 3
    Last Post: 06-09-2005, 01:10 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