go in the properties of Textbox1 and use the linked cell property to tie
Textbox1 to Cell A5.

to read the content using VBA

vVar = Worksheets("Sheet1").Textbox1.Text

--
Regards,
Tom Ogilvy

"Shashi Bhosale" wrote in message
...
Hi,

I have a TextBox Object on Sheet1, name is TextBox1.
How do i read content of TextBox1 ?
Also i want to write a formula for cell A5 so that content of TextBox1
will
be transferred to A5.

Thanks in advance,

Shashi