+ Reply to Thread
Results 1 to 2 of 2

Form with drop downs in!

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Portsmouth
    MS-Off Ver
    Excel 2007
    Posts
    11

    Question Form with drop downs in!

    Hi. I have recently discovered the simple forms tool in excel, and today thought that it would be fantastic for a project

    I have a team of people who I need to go through some old files and pull out certain information.

    They need to give me very clear answers to feed into a database.

    I want to create a form that they can easily fill in for each file that limits the answers to the required set given to them. the Answers are variants of the following:
    Yes
    Yes but with restriction A
    Yes but with restriction B
    No
    Not recorded

    I set up with data validation dropdowns but can't access them in the form when produced.

    A is it possible - or is this a complex pipe dream!

    Any help gratefully received!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,933

    Re: Form with drop downs in!

    What is the simple forms tool you are talking about? Is this the one that displays a form showing fields in a record based on rows, but you don't have to do any form design to create it?

    The keyword there is simple. There is a tradeoff when you use something simple that it also is not feature-rich. If you want a dropdown on a form, you have to design a form in VBA and use a combobox.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Creating form notes using drop downs ?
    By loracarol in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-18-2019, 02:18 PM
  2. Need help in creating a form with drop downs
    By nileshsompura in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2018, 06:53 AM
  3. Cascading two tier drop downs in form control
    By ehardway111 in forum Excel General
    Replies: 5
    Last Post: 06-07-2013, 04:36 PM
  4. 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
  5. Replies: 1
    Last Post: 07-03-2012, 08:19 AM
  6. Drop downs in Data Form
    By Gator9 in forum Excel General
    Replies: 4
    Last Post: 11-11-2005, 07:45 PM
  7. [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

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