On Thu, 12 Aug 2010 04:07:35 -0700, AllInTheChi
wrote:



Title says it all practically. I have a msgbox pop up at times in my
code to tell me about progress plateaus. What I want to do is
incorporate cell value calls, etc. in the msgbox text. Can I use
"CONCATENATE" or other cell functions within macro code?

Yes. Just use the concatenation operator ( & ) to produce your
string.

Something like:

var1 = "Is the Date "
var2 = #9/1/2010#
var3 = " OK?"

s = var1 & var2 & var3
MsgBox (s)