I would like to know how I can take different cells (non concurrent)
and string them together in another cell with separators. The
CONCATENATE function can't do this. The end result that I am looking
for is to select a number of cells using a userform and listbox with
checkboxes, and have all of those values combine and be pasted into a
cell of my choosing. I have the userform, the listbox, and the
checkboxes (courtesy of John Walkenbach's book), I need to figure out
how to combine my selections into a single cell.

Thanks for your reponses in advance.


Shane

Concatenate should do what you are asking. Can you give an example of the
data you are trying to concatenate and the results? Also show what incorrect
results you are getting.

"(E-Mail Removed)" wrote:

> I would like to know how I can take different cells (non concurrent)
> and string them together in another cell with separators. The
> CONCATENATE function can't do this. The end result that I am looking
> for is to select a number of cells using a userform and listbox with
> checkboxes, and have all of those values combine and be pasted into a
> cell of my choosing. I have the userform, the listbox, and the
> checkboxes (courtesy of John Walkenbach's book), I need to figure out
> how to combine my selections into a single cell.
>
> Thanks for your reponses in advance.
>
>
> Shane
>
>

I should have been more specific. I would like to have them divided by
commas. I have found a few functions where I can put commas in, but if
I choose cells that are non-concurrent I get a #VALUE error.

=A1&","&B1&","&C1

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Shane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I should have been more specific. I would like to have them divided by
> commas. I have found a few functions where I can put commas in, but if
> I choose cells that are non-concurrent I get a #VALUE error.
>

I would like to add to vba code so I can string together cell
selections chosen using checkboxes from a listbox in a userform

See one answer with a macro in excel.newusers

No listboxes, just select the cells from the worksheet.


Gord Dibben MS Excel MVP

On Wed, 15 Aug 2007 21:56:04 -0000, Shane <(E-Mail Removed)> wrote:

>I would like to add to vba code so I can string together cell
>selections chosen using checkboxes from a listbox in a userform

So it is just

myVar = If Checkbox1.Value Then Range"A1").Value & ","
myVar = myVar & If Checkbox2.Value Then Range"B1").Value & ","
myVar = myVar & If Checkbox3.Value Then Range"C1").Value & ","
'etc.
myVar = Left$(myVar,Len$(myVar)-1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Shane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I would like to add to vba code so I can string together cell
> selections chosen using checkboxes from a listbox in a userform
>