Hi, im trying to get the value from the combo box to filter the data in sheets as i dont use userform. but the combobox value cant be detected. i didnt know if i dont declared it as string or because of the value inside the combo box is too long. i used 2 code to add value in combo box (array & manually add . additem). When the user select the value inside combo box the ACO category will automatically filter to the selection only. [Blocked Image: https://www.mrexcel.com/forum/images/smilies/confused.png]
Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'COMBO BOX LIST For Each cell In [Category] Me.cbo_cat.AddItem cell Next cell 'With cbo_cat '.AddItem "A - Administration", 1 '.AddItem "B - Finance", 2 '.AddItem "C - Specialist", 3 '.AddItem "D - Industrial", 4 '.AddItem "E - Professional", 5 '.AddItem "F - Technical", 6 '.AddItem "G - ICT Network & Equipment", 7 '.AddItem "H - ICT Management Implementation & Support", 8 '.AddItem "I - Applications, Databases & Systems ", 9 '.AddItem "J - Transport", 10 '.AddItem "K - Education", 11 '.AddItem "L - Other", 12 'End With End Sub
im try both ways to add but the array is looping the data inside the combo box and the manual additem is error.
im attach 2 picture to give you guys some idea.