TextBox1.Text = Worksheets("Sheet2").Range("A1").Value

--
HTH

Bob Phillips

"thmort" wrote in
message ...

I have a form that I'm using to get values to put into various
worksheets.

On some of the forms I'd like to in turn get some calculated values
from the worksheets and display them in a textbox.

I haven't been able to figure out how to do this.

It seems like it should be simple.

I can go in the other direction, putting the textbox values from the
form into the worksheets.

Thanks


--
thmort
------------------------------------------------------------------------
thmort's Profile:
http://www.excelforum.com/member.php...o&userid=25296
View this thread: http://www.excelforum.com/showthread...hreadid=387819