MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying data from an Userform

Posted by Josh on January 14, 2002 4:45 PM

I'm having a hard time locating a copy command that that will pull data off, say a textbox of a userform, and either putting it on the clipboard or copying the data to a cell on a worksheet.

as always...thanks for any help...

Posted by Jacob on January 14, 2002 7:34 PM


What do you want to copy? Try these
Dim MyValue

MyValue = listbox1.value
MyValue = Label1.caption
MyValue = commandbutton1.caption


Does this help?