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.
Code:
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