Listbox to String

Hi all

I have a Userform with a listbox called listbox2
I want the entire contents of this list box to be in a string in Variable Recs

I have this

Please Login or Register  to view this content.

And it works
but I believe there is an easier way to do it
I think using the list properity

Please Login or Register  to view this content.

I don't think that you can avoid the loop, how is the listbox populated?

If you populated using List or Rowsource (assuming a one column range) then you'll need to transpose before you join; if you used additem, then you need to loop.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

which method is that?

How do you transpose?

Nicely contrived.
Now try this:

Please Login or Register  to view this content.

ok having a play with that.

got my head round the examples. i think.
so transpose only works when the listbox is populated in one of the above ways?

so will i be stuck with the loop?

Since you haven't told us how you are populating it, we can't really say.

[QUOTE=FRIEL;2558478]

Please Login or Register  to view this content.

QUOTE]

sorry this is in the Initialize event on the form

Then you need to use Join and application.Transpose as shown.

=/

any reason this wont work?

Please Login or Register  to view this content.

Depends - how is Listbox2 being populated?

=S

ok lil wired
the above works now
it wouldnt work before.

thanks guys

I'd add Rep
but i added Rep to you last time and it wont let me add to you again lol

=S Now it dosent!

this is kinda frustrating.....

Populated by

Please Login or Register  to view this content.

in the Initialize event

You refer to Listbox1 in one code and Listbox2 in the other - which is it? Also, it helps if you tell us what error you are getting: we always want more information than "it doesn't work"

I don't really care about the rep, though I thank you for the thought.

Please Login or Register  to view this content.

like this
what an idiot.
i totaly missed that

Run-time error '13':
Type Mismatch

sorry for the confusion

Since you are populating Listbox2 with additem, you'll have to loop.

ok
thanks for your help

at least i have learned somthing =D

Please Login or Register  to view this content.

I assume you don't expect a response to that?