Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-10-2017, 03:34 PM
peterpiper peterpiper is offline Windows 7 64bit Office 2007
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
Attached Files
File Type: xlsx example1.xlsx (8.3 KB, 14 views)
Reply With Quote
Old 07-11-2017, 03:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,230
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

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 !
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote

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 02:41 AM.

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