Transfer String Data from Textbox to Textbox

Hi all,

Is it possible to transfer a string of text from an object textbox to a shapes textbox? I have a form created in VBE that has a textbox and an enter button. I would like to take the entered data from that textbox and transfer it to another textbox located on a sheet.

-Michael

Hello Mordred,

Yes, you can. What is the name of the Shape and what the name of the sheet it is on?

Hi Leith Ross,
The shape is called PrintBox and it is located on Sheets("Graphs")

Edit to last post, the textbox is called PrintBox

Hello Mordred,

Both objects are named "PrintBox" ?

LoL, no the sheet textbox is called PrintBox while the userform textbox is called TextboxInsert. Sorry for being daft today!

Hello Mordred,

You may need to change the name of the user form if it is not named "UserForm1".

Please Login or Register  to view this content.

Hi Leith Ross,

I receive the error "Run time error '438': Object doesn't support this type of property or method" on the following line:

Please Login or Register  to view this content.

Hello Mordred,

The error indicates the Shape Object does not have a text frame. How did you creae this text box?

Hi Leith Ross,

I created it using the Contro Toolbox within the spreadsheet. If I record a macro to select it, I get this:

Please Login or Register  to view this content.

Hello Mordred,

This should work...

Please Login or Register  to view this content.

Hi Leith Ross,
Thanks so much for your patience with me. The only change I had to make was

Please Login or Register  to view this content.

and then it works like a charm.

Hello Mordred,

See, you are not alone being a wee bit daft!

or

Please Login or Register  to view this content.