Thread: Copy/Paste from worksheet to textbox in userform

Hello,
I have created a userform with a listbox and a textbox. The listbox lists the names of all the ListObjects on the active worksheet. When one is selected, the listObject's contents are displayed in the textbox for editing. I need to be able to copy single columns of numbers from other workbooks and paste them into the textbox in my userform. This is difficult, as all other workbooks are locked out when the userform is displayed, and even if I copy the cells before displaying the userform, the cells seem to get dropped from the clipboard before I can hit the "paste" button that I added to the form. Any ideas?

Thanks,
Jarrod

Brilliant! I knew it had to be something simple I was overlooking. Thank you so much.

This solves half the problem. The other half remains.

1. I click the control button in workbook A to open my userform.
2. I navigate to Workbook B and select/copy the needed cells.
3. When I go back to workbook A and click the "Paste" button I added to the form, nothing happens. It works if I keep workbook B active and click "Paste." What gives? Here's the code for the pasting process:

Code:

Private Sub BTNpaste_Click()
Dim cbUPCs As String

If LBmyGroups.ListIndex <> -1 Then
    cbUPCs = ParseData
    TBupcs.Text = cbUPCs
End If

End Sub

Function ParseData() As String
   Dim objData As MSForms.DataObject
   Dim varData, strData As String
   
   Set objData = New MSForms.DataObject
   On Error Resume Next
   objData.GetFromClipboard
   ParseData = objData.GetText
End Function

Thanks for your help!

Unfortunately, due to the nature of the work, I can't post the workbook here.

The reason I chose to utilize cut and paste is that the user won't necessarily be choosing *all* of the numbers from the secondary workbook, and they might be pulling numbers from several different workbooks.

Unfortunately, due to the nature of the work, I can't post the workbook here.

The reason I chose to utilize cut and paste is that the user won't necessarily be choosing *all* of the numbers from the secondary workbook, and they might be pulling numbers from several different workbooks.