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 offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,988
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice

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)
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 04:13 PM.

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