Listbox That Controls Second Listbox
Loading...
Loading...
14,390
Loading...
Uploader Comments (wjj4832)
see all
All Comments (2)
-
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!.
-
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
Loading...
5:06
Create dependent drop down lists in Excel.aviby Computergaga5,075 views- 4:42
MultiSelect ListBox 2by ExcelSupernerd4,819 views
- 12:38
List Box & Combo Box In VB6by akaban019,438 views
- 1:06
Using the Multiple Selection Drop-Downby ProjectInsightPMSW4,571 views
- 7:37
Creating a cascading drop down listby billsecond17,730 views
- 6:17
List Box projectby NileshBaviskar6,559 views
- 1:40
Showing search results in a Listbox while entering text in a textbox - See Desc. for codeby msaccessdev23,994 views
- 4:04
MultiSelect ListBox... how do you read those values??by ExcelSupernerd7,224 views
- 6:45
Linking Data from Different Excel Sheets and Workbooksby ExcelFormulas19,493 views
- 6:38
Use the INDIRECT() Function to Create a 2nd Pick From List in Excelby DannyRocksExcels8,816 views
- 3:47
Add Combo Box Drop Down List to Excel Worksheetby contextures42,397 views
- 2:59
How To Add List Values To A (Combo box) Dropdown Box Field Automatically In A PDF Form In Acrobatby formrouter9,467 views
- 10:49
when Combo Box change, list box changeby centurychallenger4,362 views
- 4:42
MultiSelectListBox.wmvby ExcelSupernerd3,927 views
- 5:33
Visual Basic 2008 - Using a ListBoxby uMihnea7,938 views
- 4:04
Adding combo boxesby imagination19656,987 views
- 4:58
Different Drop Down Lists in Same Excel Cellby contextures28,020 views
- 8:09
ASP.NET CSharp Move Data from ListBox To ListBoxby borisdonbergs3,292 views
- 4:05
Proyecto Tutorial Listbox.aviby AMExcelChannel3,098 views
LoadSubcategories Code:
Public Sub LoadSubcategories(strSubName As String)
ufSelections.lbSubcategory.Clear
Range(strSubName).Offset(1, 0).Activate
While ActiveCell.Value > " " ufSelections.lbSubcategory.AddItem (ActiveCell.Value) ActiveCell.Offset(1, 0).Activate
Wend
Range(ufSelections.lbCategory.Text).Activate
End Sub
wjj4832 3 years ago
Click event for the first listbox:
Private Sub lbCategory_Click()
Call LoadSubcategories(lbCategory.Text)
Range(lbCategory.Text).Activate
End Sub
wjj4832 3 years ago