Copy Userform ListBox AND TextBox values

  • Thread starter Thread starter Jock
  • Start date Start date
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.
 
Back
Top