Excel VBA Combo Boxes Dependency used dynamically in USERFORM (Tutorial) скачать в хорошем качестве

Excel VBA Combo Boxes Dependency used dynamically in USERFORM (Tutorial)

Please subscribe to my channel For MORE FREE Tutorials. Creating Dependent Combo Boxes in Excel with standard User Form function using VBA coding to dynamically populate combo boxes (Tutorial) SEE CODE FOR COPYING AND PASTING BELOW: Email me if you would like the code. USE LINE OF CODE: Option Explicit Private Sub ComboBox1_Change() Dim index As Integer 'list combobox 1 and look for dependency index = ComboBox1.ListIndex ComboBox2.Clear 'find value Select Case index 'manual input Case Is = 0 With ComboBox2 .AddItem "Food" .AddItem "Pride" .AddItem "Harry" End With Case Is = 1 'Call content in range C dynamically With Worksheets("sheet1") ComboBox2.List = .Range("c2:c" & .Range("c" & Rows.Count).End(xlUp).Row).Value End With End Select End Sub Private Sub CommandButton1_Click() 'populate range A1 in sheets 1 Range("A1").Value = ComboBox2.Value End Sub Private Sub userform_initialize() 'dynamically call combobox1 when form initialize 'please keep line of code for credit. hall written 2016 With Worksheets("sheet1") ComboBox1.List = .Range("b2:b" & .Range("b" & .Rows.Count).End(xlUp).Row).Value End With End Sub