Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-10-2017, 03:34 PM
peterpiper peterpiper is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jun 2017
Posts: 4
peterpiper is on a distinguished road
Unhappy Can i make excel retrieve selected text?

Hello all

Is it possible to make excel retrieve text from a list, I have attached an example file so i hope that helps.

In this example, I want to select from a menu 1 or more famous names and have the desired text (quotes in this example) appear in a text box that I can then copy from.

SO i can choose person a and this will bring up the full quote but also if i choose person A &B both quotes will appear in the same text box.



I hope this all makes sense.

Thanks in advanced
Peter
Attached Files
File Type: xlsx example1.xlsx (8.3 KB, 14 views)
Reply With Quote
  #2  
Old 07-11-2017, 03:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,914
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

You can use the VLOOKUP function, but I wonder if MSWord would not be better suited , as lots of text seems to be involved?
Perhaps give it a try on that forum, macropod and his colleagues are among the best !
Reply With Quote
Reply

Tags
activex control, formula help

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel does not work if any other excel file selected in any folder tonytonytony Excel 3 03-10-2016 04:18 PM
Delete Text when selected. Eduardo Care Word VBA 1 11-03-2015 05:49 PM
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
Retrieve page numbers in Word doc from set of variables in Excel file smn Word VBA 6 06-29-2014 06:32 PM
How to retrieve text from a word content control in VBA jeffaus Word VBA 1 03-14-2013 11:42 PM


All times are GMT -7. The time now is 06:46 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft