+ Reply to Thread
Results 1 to 7 of 7

Create drop down in table form

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Create drop down in table form

    Hello Excel friends,
    I want to create a form to enter data into a table, but I want the first field in the form to be a drop down list from which to select the appropriate data.
    I need this because the field will be names and titles and every occurrence must be correct and identical to names in a db.
    If this can be done, please show me how.
    I've attached a sample text table.
    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Create drop down in table form

    You can use List within data validation.

    If the range of names to be included is dynamic then use a named formula to define the list.

    NAMELIST: =Sheet2!$A$2:INDEX(Sheet2!$A:$A,COUNTA(Sheet2!$A:$A))

    Then select rows of first column, on the ribbon use Data > Data Tools > Data Validation.
    Add a list and use the range =NAMELIST
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Create drop down in table form

    Attachment 645419
    Hello Andy, thank you so much for responding and offering your assistance.
    Either you misunderstood me or I am misunderstanding what you are telling me. So, I've added a couple of pics to show what I'm doing.
    If you look at pic2 you'll notice a form on the far right that has the three fields from the table. The first field is titled ONE. I wish for THAT FIELD to be a dropdown list (from column A) that permits the user to select one of the names from the list.
    If you look at pic1 you'll see that I created the NAMELIST name.

    So, given this, is it possible for ONE: in the FORM to be a dropdown list?

    Thanks again to you and anyone else who attempts to help me.

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Create drop down in table form

    Attachment 645422
    Here's pic1

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Create drop down in table form

    Your attachments are invalid so I can not see them.

    This example has the named range defined and then data validation, using the list NAMELIST, applied to column ONE.
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Create drop down in table form

    You will not be able to use this approach when using the built-in Data Form.

    If you need that sort of functionality you will need to create a userform

  7. #7
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Create drop down in table form

    Okay thanks

+ 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. [SOLVED] Trying to create a dynamic table so I can create a updating drop down list.
    By sbobster15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2019, 11:43 AM
  2. Create Drop Down Menu ORDER FORM with Variations
    By chosen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2017, 10:29 AM
  3. Best way to create form with multiple cascading drop downs.
    By 123Excel00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 05:06 AM
  4. Create Drop Down List Within A Form
    By lvmineoster21 in forum Excel General
    Replies: 7
    Last Post: 02-11-2011, 11:07 AM
  5. How do I create a drop down using Access 2007 Form?
    By Dhoang25 in forum Access Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2010, 05:57 PM
  6. [SOLVED] How do I create a form with drop downs that narrows choices?
    By Joeglobal in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 06:05 PM
  7. How do I create drop down form fields in Excel?
    By Micki in forum Excel General
    Replies: 1
    Last Post: 06-05-2005, 09:40 PM

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