How to pass data in Array to Message Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I have data in array strRecTo (0,14) whre data is collected using several IF....Then...Els

I would like to pass this data to Message Box, just I do not know how.

the simple code looks like

dim strRecTo (1, 14) as Strin
Dim Counter as Intege
Counter =
While Counter <=1
If (condition) the
strRecTo (0, 1) = "something 1
Else
Counter = Counter +
 
Senad said:
Hi Everyone,

I have data in array strRecTo (0,14) whre data is collected using
several IF....Then...Else

I would like to pass this data to Message Box, just I do not know how.

the simple code looks like:

dim strRecTo (1, 14) as String
Dim Counter as Integer
Counter = 0
While Counter <=14
If (condition) then
strRecTo (0, 1) = "something 1"
Else
Counter = Counter +1
.
.
If (condition) then
strRecTo (0, 13) = "something 13"
Else
Counter = Counter +1
Wend
MsgBox ("Message needs to be send to: AND NOW i WOULD LIKE TO HAVE
DISPLAYED MY ARRAY SEPARATED WITH COMAS OR COLUMN)

Thanks in Advance
Senad
Click to expand...

Does your array really have two dimensions? Could you use a
one-dimensional array instead? If so, the Join() function is
tailor-made for what you're asking.
 
I guess I can make it one dimensional. At least I will try. Would it be too much to ask for example of Join() function in MsgBo

----- Dirk Goldgar wrote: ----

Senad said:
Hi Everyone
Dim Counter as Intege
Counter =
While Counter <=1
If (condition) the
strRecTo (0, 1) = "something 1
Els
Counter = Counter +


If (condition) the
strRecTo (0, 13) = "something 13
Els
Counter = Counter +
Wen
MsgBox ("Message needs to be send to: AND NOW i WOULD LIKE TO HAV
DISPLAYED MY ARRAY SEPARATED WITH COMAS OR COLUMN
Sena
Click to expand...

Does your array really have two dimensions? Could you use
one-dimensional array instead? If so, the Join() function i
tailor-made for what you're asking
 
Back
Top