Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning text using a formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Returning the formula in a cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |