+ Reply to Thread
Results 1 to 6 of 6

Dynamic drop down in Userform From Dynamic list

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Dynamic drop down in Userform From Dynamic list

    Hi good people!,

    I am searching and found many tutorials on creating dependant, multi-level drop downs in a user form, from fixed source lists in a spreadsheet. Really what I am looking for is to create multi-level dependant drop downs in a user form, with the difference that the first drop down in the user form, is sourced from a dynamic list on the sheet.
    This is what I am trying to accomplish:
    Rows 2 and down from columns A to E are populated as time goes by. column A being user, column B being timedate stamp, C is Company, D is Item and E is Cost. Sometimes an entry would have to be altered, not deleted, and mostly it is the cost figure that would need changing, so I am thinking to populate the fields in the user form starting with the company name, then the 2nd drop down must populate depending on this input, and the third drop down will change depending on the second input.. Using the picture:
    drop down 1 displays AA,BB,CC,DD,EE. Selecting for example AA, will cause the second drop down to display aa,dd..Selecting aa will display 44 and 48n in the third drop down. In the 4th drop down which is on the user form, I want to input a cost figure, which then, when I click a command button, will find the row of which the company, and Item and cost match the fields in the user form, and change the cost figure of that record to the new cost figure which was input in the 4th text box.

    The reason we cannot just let a user find the entry by doing a search manually, is because the sheet is password protected and nobody can select any cells.

    I sincerely hope someone will be able to assist me. Thank you all very much!
    Attached Images Attached Images
    Last edited by juriemagic; 05-30-2019 at 10:05 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,161

    Re: Dynamic drop down in Userform From Dynamic list

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,516

    Re: Dynamic drop down in Userform From Dynamic list

    Any tutorial on dependent dropdown lists should be easily adapted to work with dynamic ranges.

    All you should need to adjust is the range references in the code accordingly.

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Re: Dynamic drop down in Userform From Dynamic list

    Hi guys,

    file attached. Thank you very much..
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    255

    Re: Dynamic drop down in Userform From Dynamic list

    guys,

    don't work on this..there are other ways to accomplish what I want to achieve. Thank you anyways..

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    45,405

    Re: Dynamic drop down in Userform From Dynamic list

    I suggest you mark the thread as solved.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Replies: 4
    Last Post: 01-16-2019, 10:20 AM
  2. Dynamic Drop Down Menu Ignoring Blank Cells (Dynamic)
    By RaveStarStyle in forum Excel General
    Replies: 12
    Last Post: 10-23-2018, 01:03 PM
  3. [SOLVED] Dynamic Drag and Drop Image (on Userform)
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2017, 10:04 PM
  4. Create dynamic drop down list from dynamic data source
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2016, 05:22 PM
  5. [SOLVED] Help with Dynamic Validation Lists / Drop Downs / dynamic filters
    By rjnc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2016, 08:10 PM
  6. [SOLVED] Dynamic ComboBox (Drop down) menu in a VBA UserForm
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2015, 05:07 AM
  7. [SOLVED] Dynamic Ranges as drop down lists based on another drop down list
    By Excel_Beginner_1 in forum Excel General
    Replies: 4
    Last Post: 05-15-2012, 03:31 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