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

Hi

What do you want to copy? Try these
Dim MyValue

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

etc

Does this help?

HTH

Jacob