have you opened a text box and then run the macro?
If you have not you have to add another code statement(s) for opening the text box . I shall look into it and write to you
ilooked into it if you have not already opened a textbox use this sub
Public Sub textbox()
Set mydocument = Worksheets(1)
100, 100, 200, 50) _
.TextFrame.Characters.Text = "my name is venkat"
you can get this in the help <add textbox example>
I had already added a textbox and I wasn't editing the text when using the macro.
I wanted to make it so that I entered some data in a cell, run a macro and the data would be copied to the text box.
I managed to record a macro on my home computer to do it and I've used the same code on my work computer and it works.
The code I used (which I've modified so it copies the text and pastes it in the box) is
Dim text1 As String
text1 = Sheets("DETAILS ENTRY").[D2]
Sheets("PRICEPACK").Shapes("Text Box 30").Select
Selection.Characters.Text = text1
.name = "Arial"
.Size = 30
Selection.Font.Bold = True
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter