Userforms in Excel 2003
 

How do I draw information from a cell within Excel and show this on a
label/caption on a Userform?

Userforms in Excel 2003
 

try:
userform1.label1.caption = worksheets("sheet1").range("A1").value

--


Gary


"Elsa" wrote in message
...
How do I draw information from a cell within Excel and show this on a
label/caption on a Userform?

Userforms in Excel 2003
 

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?

Userforms in Excel 2003
 

Thank you. I will try this.

"Gary Keramidas" wrote:

try:
userform1.label1.caption = worksheets("sheet1").range("A1").value

--


Gary


"Elsa" wrote in message
...
How do I draw information from a cell within Excel and show this on a
label/caption on a Userform?

Userforms in Excel 2003
 

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?