Listbox That Controls Second Listbox

[wayunet]

Hello wjj4832 thankyou for you video,but in my case when properly part of the code you show here on youtube to my project the compiler error I mark the following line of code:

ufselections.ListBox2.Clear

Thanks for your help!.

[ninjainsaudia]

hello sir, excellent method. but the quality of recording is blur, could you please post the codes for this video or send to my mail thanks a lot

[wjj4832]

LoadSubcategories Code:

Public Sub LoadSubcategories(strSubName As String)

ufSelections.lbSubcategory.Cle­ar

Range(strSubName).Offset(1, 0).Activate

While ActiveCell.Value > " " ufSelections.lbSubcategory.Add­Item (ActiveCell.Value) ActiveCell.Offset(1, 0).Activate

Wend

Range(ufSelections.lbCategory.­Text).Activate

End Sub

[wjj4832]

Click event for the first listbox:

Private Sub lbCategory_Click()

Call LoadSubcategories(lbCategory.T­ext)

Range(lbCategory.Text).Activat­e

End Sub