Transferring cell data to textboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a textbox through the Control Toolbox in the Visual Basic toolbar.
I tried to transfer data from an Excel cell to it by using the following
commands

myName = Range("Name")
ActiveSheet.Shapes("txtOwnerName").Select
Selection.Characters.Text = myName

however I get the error "Object doesn't support this porperty or method."
Is there some other way to get data to it? It works if I create a textbox
using the Drawing toolbar, but there are limitations with this type of
textbox.

Thank-you!
Merlin
 
Activesheet.OleObjects("TxtOwnerName").Object.Value = Range("Name").Value

or possibly

Activesheet.TxtOwnerName.Value = Range("Name").Value
 

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

Changing text in a Text Box 4
Userform Textbox to Worksheet Textbox 1
Textbox form to Textbox in worksheet 4
Textbox macro - update problem 5
VBA code causes Find and Replace dialog box to lose focus 2
possible to enumerate objs from drawing toolbar - like textbox in 4
Change text in textbox in chart in Excel 2007 1
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

Back
Top