Copy Userform ListBox AND TextBox values
Ignore last - I have managed to do it.
--
Traa Dy Liooar
Jock
"Jock" wrote:
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.
--
Traa Dy Liooar
Jock
|