Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Userform ListBox AND TextBox values
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
Reset TextBox values on userform | Excel Programming | |||
Paste values from TextBox to ListBox | Excel Programming | |||
Keeping Textbox Values After Reopening Userform | Excel Programming | |||
Adding up values of textbox in Userform | Excel Programming |