Results 1 to 6 of 6

Dynamic drop down in Userform From Dynamic list

Threaded View

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

    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.

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