Dave!!..Label Caption Inherits Cell Value--Can't get to work

Posted by Patrick on April 15, 2001 9:00 AM

Hi
This was posted earlier on
14216.html
I just want the Label on the form to inherit cell's
A2 value on a worksheet named "RawWasteForm"....
Just can't get what was posted to work!!
I'm working with a form that has a multi page tab
on it......Label1 is on Page1 of the Multi
Thanks.....

Posted by g-man on April 15, 2001 12:17 PM

Try changing the macro line naming the label to:

Label1.Caption = sheet1.Range("a1").value

g-man

Posted by Patrick on April 15, 2001 1:29 PM

Thank You Thank You Thank You!!!!!!!