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

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

I am using One of the shapes as text box and there is no option to
associate cell in that.
please help.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!