Where do you put this code?
"Chip Pearson" wrote:
Elsa,
If you have a Label control named lblCaption on your form, you can use
something like the following:
UserForm1.lblCaption.Caption = Worksheets("Sheet1").Range("A10").Text
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"Elsa" wrote in message
...
How do I draw information from a cell within Excel and show this on a
label/caption on a Userform?