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?

On Thu, 12 Aug 2010 07:47:46 -0400, Ron Rosenfeld <(E-Mail Removed)> wrote:

>On Thu, 12 Aug 2010 04:07:35 -0700, AllInTheChi
><(E-Mail Removed)> 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)

Cool. Thanks. I keep forgetting about making declarations right there
in the code.

Can I use range names and thereby extract cell values on the fly?

Example... Application.WorksheetFunction.Sum
Use "&" in place of Concatenate... "Smith" & "Wesson" equals "SmithWesson"
See "List of Worksheet Functions" in Excel help.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html

..
..
..

"AllInTheChi" <(E-Mail Removed)>
wrote in message
news(E-Mail Removed)...
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?

On Thu, 12 Aug 2010 19:42:47 -0400, Ron Rosenfeld <(E-Mail Removed)> wrote:

>On Thu, 12 Aug 2010 04:52:18 -0700, AllInTheChi
><(E-Mail Removed)> wrote:
>
>>On Thu, 12 Aug 2010 07:47:46 -0400, Ron Rosenfeld <(E-Mail Removed)> wrote:
>>
>>>On Thu, 12 Aug 2010 04:07:35 -0700, AllInTheChi
>>><(E-Mail Removed)> 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)
>>
>> Cool. Thanks. I keep forgetting about making declarations right there
>>in the code.
>>
>> Can I use range names and thereby extract cell values on the fly?
>
>Yes


Thanks to the both of you...