Cell contents check and prompt out message (By using Macro)

's Computer Specifications

Hi all,

Could you know how to use Macro to check the cell contents with specified
"String" and prompt out Message box?

E.g. If the Column B1 = "USA" and Column H1 ="Mexico" , prompt the message
box "USA and Mexico are found".

Thanks,
Tlee

's Computer Specifications

I'm thinking you want something like this

Msgbox(Range("B1") & " and " & range("H1") & " are found.")

This assumes that these ranges are on your active sheet.

"tlee" wrote:

> Hi all,
>
> Could you know how to use Macro to check the cell contents with specified
> "String" and prompt out Message box?
>
> E.g. If the Column B1 = "USA" and Column H1 ="Mexico" , prompt the message
> box "USA and Mexico are found".
>
> Thanks,
> Tlee
>
>
>

's Computer Specifications

I've used the examples here

http://www.cpearson.com/excel/vbe.aspx

to get to Modules and Procedures. Try it and if it doesn't work, come back
and post what you have.

HTH,
Barb Reinhardt

"tlee" wrote:

> Hi all,
>
> Could you know how to use Macro to check the cell contents with specified
> "String" and prompt out Message box?
>
> E.g. If the Column B1 = "USA" and Column H1 ="Mexico" , prompt the message
> box "USA and Mexico are found".
>
> Thanks,
> Tlee
>
>
>

's Computer Specifications

This was a reply to another post.

"Barb Reinhardt" wrote:

> I've used the examples here
>
> http://www.cpearson.com/excel/vbe.aspx
>
> to get to Modules and Procedures. Try it and if it doesn't work, come back
> and post what you have.
>
> HTH,
> Barb Reinhardt
>
> "tlee" wrote:
>
> > Hi all,
> >
> > Could you know how to use Macro to check the cell contents with specified
> > "String" and prompt out Message box?
> >
> > E.g. If the Column B1 = "USA" and Column H1 ="Mexico" , prompt the message
> > box "USA and Mexico are found".
> >
> > Thanks,
> > Tlee
> >
> >
> >

's Computer Specifications

Barb,

Thanks for your help and information.

I would like to use control flow to check the cell "B1" and "H1" such as if
statement. After checked, promot message or continous run the code.

Thanks
Tlee

> I'm thinking you want something like this
>
> Msgbox(Range("B1") & " and " & range("H1") & " are found.")
>
> This assumes that these ranges are on your active sheet.
>
>
> "tlee" wrote:
>
>> Hi all,
>>
>> Could you know how to use Macro to check the cell contents with specified
>> "String" and prompt out Message box?
>>
>> E.g. If the Column B1 = "USA" and Column H1 ="Mexico" , prompt the
>> message
>> box "USA and Mexico are found".
>>
>> Thanks,
>> Tlee
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vba to check cell contents	Steve	Microsoft Excel Misc	1	29th Jul 2009 04:57 PM
'IF' Macro to insert cell contents to alternate cell if cell not e	Gryndar	Microsoft Excel Worksheet Functions	6	20th Dec 2008 05:02 PM
Macro to clear range contents when cell contents are changed by us	=?Utf-8?B?U3RldmUgRQ==?=	Microsoft Excel Programming	12	22nd Feb 2007 09:09 PM
Macro to remove contents of cell and move all other contents up one row	adw223	Microsoft Excel Misc	1	1st Jul 2005 03:57 PM
Macro/message box to prompt user for their name and save name to cell	robertguy	Microsoft Excel Misc	2	3rd Mar 2004 08:58 PM