View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jock Jock is offline
external usenet poster
 
Posts: 440
Default 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