+ Reply to Thread
Results 1 to 7 of 7

Drop Down box in Data entry form

  1. #1
    Registered User
    Join Date
    08-01-2020
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Lightbulb Drop Down box in Data entry form

    Im needing some help in getting my list of locations to show up in my drop down box on my data entry form. I have watch about a million youtube videos, but I still can't get mine to work. Its a simple data entry form and only 1 is a drop down box type.

    Anyone got time to help me.

    thanks

    Monica
    Attached Files Attached Files
    Last edited by MonicaFleenor; 08-01-2020 at 08:11 PM.

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Drop Down box in Data entry form

    Hi Monica,
    Does this help?
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,371

    Re: Drop Down box in Data entry form

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Drop Down box in Data entry form

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Drop Down box in Data entry form

    Data entry often follows a pattern (Enter(save)/Retrieve(update or delete).
    The attached small demo form can be expanded as no variable is hard coded.
    Adding extra textbox labels is done by first adding an extra header to the table then add label(with caption blank) to the form.
    To add extra fields(textboxes) just add a textbox, leave its name as the next default and increase the saving loop accordinly.
    No need to rename textboxes hence shorter code when using loops to save etc.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-01-2020
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Drop Down box in Data entry form

    Thank you to you both for the help. Im just learning this excel code stuff and I haven't done anything like since I learn dos back in the 90's so i'm old trying to learn new tricks.

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Drop Down box in Data entry form

    Not as old as this one - dos is modern - to those of us that 'cut our teeth' on Fortran & Cobol.
    torachan.

+ 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] In data entry form can we create a drop down list
    By koteswar in forum Excel General
    Replies: 2
    Last Post: 10-14-2018, 07:27 AM
  2. Runtime Error 1004 when trying to use a drop down box (data entry form)
    By NickyPrim in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 10-11-2017, 03:12 AM
  3. [SOLVED] HELP: Inserting a drop down box into a Data Entry Form
    By mwinter in forum Excel General
    Replies: 12
    Last Post: 12-18-2013, 03:32 PM
  4. Drop down menu in data entry form
    By yoosed in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-15-2013, 10:25 AM
  5. Data Entry Form and drop down lists
    By AnneFr in forum Excel General
    Replies: 1
    Last Post: 10-29-2012, 08:35 AM
  6. Replies: 1
    Last Post: 04-15-2009, 02:17 PM
  7. [SOLVED] Drop-Down Menus in Data Entry Form?
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 12-29-2005, 12:25 AM

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