Copy Userform ListBox AND TextBox values

J

Jock

How can I copy the values from ListBox1 and TextBox2 from the same Userform
into the same cell on a worksheet?
I have the code to copy either one to the correct location but I need to
merge the values from both, seperated by a slash (/). I have tried using the
following but it will paste "FALSE" into the appropriate cell:

With Target
.Value = ListBox1.Value & " / " & .Value = TextBox2.Text 'copies data
to column B
End With

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Word macro that can call cells out of Excel for a find and replace 0
How do I set focus (and select text) on a text box on a modeless userform? 0
copy unique values into listbox, then modify sheet from these values 4
Extract text from a "textbox" 7
Highlight multiple items in listbox based on textbox item 1
fill userform textbox from userform listbox clik event 3
Selected ListBox item to TextBox 6

Top