Transferring cell data to textboxes
 

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

Transferring cell data to textboxes
 

Activesheet.OleObjects("TxtOwnerName").Object.Valu e = Range("Name").Value

or possibly

Activesheet.TxtOwnerName.Value = Range("Name").Value
--
Regards,
Tom Ogilvy

"Merlin" wrote in message
...
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