+ Reply to Thread
Results 1 to 2 of 2

Excel 2013-How to generate a phrase based on data selected from multiple drop down lists.

  1. #1
    Registered User
    Join Date
    12-10-2018
    Location
    US
    MS-Off Ver
    2013
    Posts
    1

    Question Excel 2013-How to generate a phrase based on data selected from multiple drop down lists.

    Hello, I am using Excel 2013. My goal is to have multiple drop down lists that you could select options from, and afterwords, generate a phrase from the options chosen. Essentially I would like each option to have a portion of the phrase and once all options are selected, the phrase is then strung together from the data selected. I would prefer if the phrase could be generated using a macro. Similar to the image below but with different outcomes of course. Phrase.png

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Excel 2013-How to generate a phrase based on data selected from multiple drop down lis

    Can you attach a copy of your file with some actual examples?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Dependent Drop down lists to generate data
    By Acousticlife81 in forum Excel General
    Replies: 1
    Last Post: 04-20-2017, 03:58 PM
  2. Replies: 0
    Last Post: 08-27-2015, 09:44 PM
  3. [SOLVED] Populate data on table based on multiple criteria and value selected from drop-down
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2015, 07:45 AM
  4. Replies: 1
    Last Post: 06-12-2014, 05:34 PM
  5. [SOLVED] Having a macro check for changes in two drop down lists and fill in cells with data (2013)
    By cueball19826 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2013, 02:38 AM
  6. Replies: 28
    Last Post: 08-15-2013, 09:38 AM
  7. Replies: 2
    Last Post: 03-11-2013, 02:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1