Reading from TextBox

  • Thread starter Thread starter Shashi Bhosale
  • Start date Start date
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
 
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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Userform textbox string to header causes unwanted double spacing 4
Arbitrary data to Textboxes in UserForm 4
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5
Firing Event in another user form 1
Two types of textbox input 1
change controlsource for textbox depending on combobox selection 2
How to count drawing object (text box) in vba 4

Back
Top