Posts by samirbhowmik

royUK : I have been quite elaborate in my explanation. To simply put, I expect my listboxes to be interdependent in terms of their selected values and finally apply the filter based on the selections. it is demonstrated in the attachement for listboxes named "Source" and "Name of Projects"

If you do not understand, thats ok, but I don't agree that my requirement and explanation are not comprehensible by anyone at all and also I stated earlier, I am just starting to work with VBA and its normal that whatever I could gather from the help of other forums and forum members, I implemented.

If you are not able to help, it would be just enough to leave a comment as such instead of keep on pointing out that my explanation is not clear or implying that I am not quite sure of my requirement

The end purpose of the userform is to effect a filter to the master data which is a table called "DynamicPath_2" located in the sheet"MDB"

royUK : Also, the values in the listboxes are based on a table called "DynamicPath_2"

royUK : Actually, in my listboxes the option of multi-select is enabled. So when for example I choose multiple values in listbox1 (named "Source"), the values in listbox2 (named "Name of Project") gets filtered based on the selections in the listbox 1.

In the file that I have attached, I am able to achieve that (please check the attachement).

What I want to achieve is that, based on the values in listbox 1 all the other listboxes should contain only the relevant values based on the selections from listbox 1 as what happens currently to list box 2.

Also if possible, the same rule should be applied to all the listboxes as in any selection in any listbox should trigger a filtering of values in all other listboxes, thus making each one of them interdependent.

royUK : <could you give me an example how it can be done please?

Hello,

I have an userform with many listboxes which retrieve the unique values from a big table which a master data table. In the userform I have multiple Listboxes which I would like make as interdependent as in when one listbox value is selected the other listboxes values get filtered automatically. Below I have a piece of code which does the work for the values selected in listbox 1 to automatically filter out contents in listbox 2

Private Sub ListBox1_Change()
Dim a() As Variant
Dim dic As Object
Dim i As Long, j As Long
  
  Set dic = CreateObject("Scripting.Dictionary")
  a = Sheets("MDB").Range("A2", Sheets("MDB").Range("C" & Rows.Count).End(3)).Value
  
  ListBox2.Clear
  With ListBox1
    For i = 0 To .ListCount - 1
      If .Selected(i) Then
        For j = 1 To UBound(a, 1)
          If a(j, 1) = .List(i) Then
            dic(a(j, 3)) = Empty
          End If
        Next
      End If
    Next
    If dic.Count > 0 Then ListBox2.List = Application.Transpose(dic.keys)
  End With
End Sub

https://www.mrexcel.com/board/…ent.1185098/#post-5780796

I have attached a sample file with data of 3 months for a test. Also, a screenshot of the Userform.

Thank you in advance to whomever who would render a helping hand to fix this for me.

Hello royUK ,

The mult-iselect is possible from the listbox property at left where for the option "MultiSelect" is set to "fmMultiSelectMulti"

Here is the file

[xpost]

[/xpost]

Hello,

I am very new to VBA. I created a Userform where I have multiple inter-dependent combo boxes which helps me to effect a filter in a Table and view the result in the first sheet. The combo boxes are poplulated with a double-click in the respective combo box. I would like to change the following:

1. I would like to change the combo boxes to list boxes as combo box only allows me to select one item at a time and with list boxes I will be able to choose multiple items.

2. Like the combo boxes could I populate a list box with a double-click which initially would be blank? And if I double-click on a different listbox it will reset all and then populate the one which is double-clicked

3. Make the list boxes inter-dependent as in with any selection on a listbox, the others will be populated automatically with relevant data

4. I would like to populate the filtered options in the respective cells under the headers (located in the range T6:AC6) in the sheet "Comparaison" with the command button "Filter Selection"

5. Clear the items filtered with either the button "Clear all Filters" or the Command Button "Reset All" in the userform.

6. Change the TextBox "N° Maco" also to a listbox and add it to the filtering option like other comboboxes.

I have commented the used VBA codes which I managed to compile so far. I added a link to a sample file with partial data of 3 months for testing.

Please help me to achieve this and try and learn this interesting coding programme.

Thank you

Hello royUK ,

Unfortunately my excel version does not have the Unique function.

Thank you.

[xpost][/xpost]

Hello,

I have a userform with multiple comboboxes where the data are based on unique values from a table "DynamicPath_2" from a sheet called "MDB". I managed to get a working code from another forum member in another site but when I apply the code to my file it makes my excel stop functionning and give an error message as "excel has stopped working". I am quite new to VBA, and I am not able to find the bug which is creating this slowdown or crash.

Could anyone help me resolve the problem by checking the code and if required even scrap the whole thing with a better piece of code?

I am attaching the file with partial data of 3 months.

Note: The table is quite large with more than 30000 rows of data

Thank you in advance