elsuji
09-30-2020, 10:49 AM
Dear Team,
I had created the userform for Add, Update, Delete the customer details. And I am having listbox for search the customers.
In this once I entered any value on Combobox2( for search customer name), the listbox will update automatically by filtering the data in sheet "Customer data" by partially matching the value typed in Combobox2 and It is working for all the function properly.
But when I am delete any customer through the userform, after that the autofilter partially not working. When the whole value is matching then only the listbox is updating.
And I want to update the header for my listbox. The header range is Sheet"Customer Data" ("A2:H2").
I don't know where I am doing mistake.
I am attaching my file here for your reference.
Please help me to solve this issue
I had created the userform for Add, Update, Delete the customer details. And I am having listbox for search the customers.
In this once I entered any value on Combobox2( for search customer name), the listbox will update automatically by filtering the data in sheet "Customer data" by partially matching the value typed in Combobox2 and It is working for all the function properly.
But when I am delete any customer through the userform, after that the autofilter partially not working. When the whole value is matching then only the listbox is updating.
And I want to update the header for my listbox. The header range is Sheet"Customer Data" ("A2:H2").
I don't know where I am doing mistake.
I am attaching my file here for your reference.
Please help me to solve this issue