+ Reply to Thread
Results 1 to 4 of 4

Userform:Filter Cascading Comboboxes initially triggered by multipage index

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Userform:Filter Cascading Comboboxes initially triggered by multipage index

    Hello,

    I'm over my head on designing a userform that's intended as a data entry tool for collecting building materials found in a single house. It's not intended to collect data on more than one house. Using the list of building materials in Sheet 1 the operator will select the material from two comboboxes. Group1 Combobox2 is populated by materials dependent on Group1 Combobox1. Names of the combobox mirrors the column on the sheet. The unique feature of all this is that Group1 combobox is triggered by the operator selecting a Multipage tab. For this sample, selecting Multipage 2 / Page4 "Wall Covering" will filter materials in Sheet 1 "Wall Coverings B18:B39"

    When all comboboxes are filled the operator will enter a value in Textbox 1 ie 100% This value should be entered in the respective control source cell in the spreadsheet.

    Notice I did not include an "Add" command button. This is intentional.

    Anyway, your opinion on this userform design is appreciated and any help with the coding is off course indebted with gratitude.

    Gal

    Userform 6.0.xlsm

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform:Filter Cascading Comboboxes initially triggered by multipage index

    To put this into perspective, I have been creating userforms for 20 years and have made all possible mistakes in my time.

    So on that basis:

    You are heading down a dead end.

    Your Data Tree is over complicated and inefficient.

    Your method of populating the comboboxes is poor

    Your method of repopulating the comboboxes is poor.


    So.

    On my sheet "Comboboxes" I have two lots of data separated by one or more blank lines.

    The userform uses the first block to populate its comboboxes in sequence.

    Row 1= Combobox1, Row 2= Combobox2 etc.


    When a combobox is changed

    the userform searches column A of my sheet "Comboboxes" for the new value, this code ignores blank lines
    So it searches blocks one and two.

    If a match is found the daughter combobox is populated
    If a match is not found then the daughter combobox is cleared.

    My code is simple by design:


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-01-2014 at 06:41 AM.

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Userform:Filter Cascading Comboboxes initially triggered by multipage index

    WOW!, Mehmetcik

    Thank you for the honest feedback. Very much appreciate you taking the time. I'm impressed with your code and how you organized my data set. I never thought to think of organizing it that way. My vba experience is not as quite advanced so it's hard for me to follow but I'l try to break it down. May I pm you?

    Gal

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform:Filter Cascading Comboboxes initially triggered by multipage index

    Always happy to help.

+ 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] VBA filter with userform comboboxes
    By koffer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 02:28 PM
  2. [SOLVED] Cascading Userform Comboboxes with Unqiue List
    By Ronjay24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2012, 10:53 PM
  3. [SOLVED] Is it possible to have cascading comboboxes in a userform that's not linked to cells?
    By Orestees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2012, 11:31 AM
  4. Cascading Country Region Comboboxes on a Userform
    By jnet in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-17-2011, 10:16 AM
  5. Determining Which Page of MultiPage Initially Shows
    By Michael Malinsky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2005, 04:05 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