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
