Transferring cell data to textboxes

[Merlin]

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

[Tom Ogilvy]

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

or possibly

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

"Merlin" <Merlin@discussions.microsoft.com> wrote in message
news:22FC946C-40EF-4BBB-A5B4-5F99EC22D0AD@microsoft.com...
> 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