Link Cell to Label Caption

So, I want Cell A1 to equal the value in lbl1.Caption. I tried:

Please Login or Register  to view this content.

but obviously that didn't work. Any ideas?

activesheet.range("a1").value = lbl1.caption

maybe???



papaitaliano wrote:
>
> So, I want Cell A1 to equal the value in lbl1.Caption. I tried:
>
> Code:
> --------------------
> =lbl1.Caption
> --------------------
>
>
> but obviously that didn't work. Any ideas?
>
> --
> papaitaliano
> ------------------------------------------------------------------------
> papaitaliano's Profile: http://www.excelforum.com/member.php...o&userid=32680
> View this thread: http://www.excelforum.com/showthread...hreadid=524861

--

Dave Peterson