Returning text using a formula
Should be able to do it with a macro. What you want to copy is the cell's
..Value
This presumes something is in B3 and that the text box named 'Text Box 1'
already exists on the sheet.
Sub CopyTextToTextBox()
Dim myText As String
myText = Range("B3").Value
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = myText
Range("B3").Select ' to get away from text box
End Sub
"AJL" wrote:
IS it possible to copy and paste text that is retuned by a vlookup? Can I
for instance set up a macro button to copy and paste the returned text into a
text box and not the formula itself?
Thanks,
Alan
|