[RESOLVED] USER FORM : ListBox population based on another ListBox value selection [VBA]

[sachinns]

Hi,

User Form :


Worksheet :



In my User form there is listbox which consists of 3 values. Rated Current_Order set 1 , Rated Current_Order set 2 , Rated Current_Order set 3.

Based on the selection of these 3 order set , values should populate in the corresponding right side listbox , "Values for the selected attribute" .

The Values are populated from the worksheet "AttrOrderSetDefinition" .(Please refer the screenshot) .

If we select 1st orderset , values from "G3" to its end should populate in the next listbox. if we select 2nd , values from "H3" should populate and similar for the 3rd.

Someone please help me for this code.

westconn1 is my daily savior .

[westconn1]

assuming that the order set are in order in the list box you can use the index of the first listbox to specify the column for the data

Private Sub ComboBox1_Click()
popnxtlist ComboBox1.ListIndex
End Sub
Sub popnxtlist(i As Integer)
dim r as range
set r = Range("g3").Offset(, i).Address
MsgBox r.address
' populate the next listbox from the data below r

note i used a combobox but a listbox would be the same
the popnxtlist can be used generically for any number of listboxes, by passing the target listbox with the listindex as a second parameter
eg if you had 4 or 5 cascading, each filled from the value selected in the previous one this procedure would save writing the code multiple times for each list box

[sachinns]

@wetconn1 Working fine as usual . Thanks a lot.