Adding list box text together

[lazyperson17]

Hello,

I have tried numerous ways of getting this to work, but i only have a limited knowledge base with which to work with. I have created a 3 column listbox and figured out all but one function. What i am trying to do is this:

Dim items
items = UserForm1.ItemList.Column(0, 0)
items2 = UserForm1.ItemList.Column(1,0)

Range("B1").Select
[COLOR=Red]ActiveCell = items + items2[/COLOR]


Range("C1") = UserForm1.ItemList.Value
Range("A1").Select

Range("A2").Select

SelectedItem.Show

The red portion is where i keep running into a problem. I have the listbox text seperated for easier use of the user, but i need the individual column text to be in one cell on the spread sheet. So what i need to do is somehow place the text gathered from Column(0,0) and add it to Column(1,0).

To sum everything up, is there a way to combine 2 or more sources of text and have it appear together in one location(cell in this case).

Thanks,

Trey

 

[lazyperson17]

Sorry, i forgot to let you guys know that im using Excel 2007

 

[jmthompson]

Try

Range("B1").Value = items + items2

 

[lazyperson17]

Thank you for the reply, i finally found the solution after some more trial and error. Alll i needed to do was include a "&" sign in the middle and it fixed the problem.