G Guest Jul 17, 2007 #1 How do I draw information from a cell within Excel and show this on a label/caption on a Userform?
G Gary Keramidas Jul 17, 2007 #2 try: userform1.label1.caption = worksheets("sheet1").range("A1").value
C Chip Pearson Jul 17, 2007 #3 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, 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)
G Guest Jul 17, 2007 #4 Thank you. I will try this. Gary Keramidas said: try: userform1.label1.caption = worksheets("sheet1").range("A1").value Click to expand...
Thank you. I will try this. Gary Keramidas said: try: userform1.label1.caption = worksheets("sheet1").range("A1").value Click to expand...
C Charlie Dec 18, 2007 #5 Where do you put this code? Chip Pearson said: 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) Click to expand...
Where do you put this code? Chip Pearson said: 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) Click to expand...
