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

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

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

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

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

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

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

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

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

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