This is also posted on MrExcel but I see no way to attach an example:
I have a list of inventory
Each item has a Category associated with it
I made a pivottable to list all the unique categories (To get rid of duplicates)
I NameRanged that table as Category
I created an activex combobox and called the ListNameRange "Category"
Now all the items from that pivot table appear on my combobox
I have the selection from that combobox get entered into another cell "AC1"
On the Change event of the Combobox, I have a filter to filter the column by whatever is in AC1 (same value as selected on the combobox)
I then have a button next to the combobox that removes the filter and all the items show.
This all works PERFECTLY........................until
I go to delete a row in the entire list and the Change event of the combobox runs and it runs the filter. Essentially taking my entire list and shrinking it down to the item displayed in the combobox
I'm lost! I wish I could explain better but I cant.
Attached is a stripped down version
The pivot table is all the way over in the AB column
On a Side Note, I found this elsewhere, but I tried it but I think I failed in understanding.
1) Delete ListFillRange property from the Property Box.
2) to ThisWorkbook module
Code
Private Sub Workbook_Open()
Application.Run "Sheet1.Worksheet_Activate"
End Sub
3) to Sheet1 module
Code
Private Sub Worksheet_Activate()
Me.ComboBox1.List = Range("b6:b10").Value
End Sub
Bookmarks