Copy embedded TextBox?

[Vet Tech]

I want to be able to copy the data from what appears to be an embedded
textbox so that I can save it elsewhere. I've not come across this
type of textbox before, so any help would be appreciated.

It appears to be called TextBox1 and in the formula bar is.... =EMBED
(Forms.TextBox.1" ," ")

I want to copy it elswhere using a line like the one below but this
doesn't work.

Workbooks(ExcelFileName).Worksheets("Working").Range("TextBox1").Copy

Any ideas?

VT

 

[Dave Peterson]

There are a couple of different textboxes you can put on a worksheet.

One comes from the Drawing toolbar. This one comes from the Control toolbox
toolbar.

worksheets("sheet2").Range("A1").Value _
= Worksheets("Sheet1").TextBox1.Value

is one way to get the value from the textbox.

Change the worksheet names to match what you need and the textbox1 name may need
to be changed, too.