Reading from TextBox

S

Shashi Bhosale

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
 
T

Tom Ogilvy

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
 
S

Shashi Bhosale

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!
 
Top