PDA

View Full Version : MsgBox - Displaying two values



Giri
04-19-2011, 04:07 AM
Hi Guys,

Could anyone please tell me how to display two
values from two different cells (eg. "A1" and "B2")
in a MsgBox?

Currently I have defined the range using:

Set Msg = Workout1.Resize(1, 2)
where "Workout1" refers to a particular cell. I would like
to display the contents of "Msg".

Thanks for your help!

Kind Regards,

Giri

Bob Phillips
04-19-2011, 04:38 AM
MsgBox Msg.Cells(1, 1).Value & ", " & Msg.Cells(1, 2).Value

Giri
04-20-2011, 08:14 PM
Thanks, xld!

How do I mark threads as solved?

Bob Phillips
04-20-2011, 11:46 PM
Thread Tools on the header bar above the first post in the thread.