search engine using textbox and combobox

[blxckish]

Hai, i have create a search engine using a textbox and combobox. user will need to choose column from combobox and enter the value in textbox to filter. this filtered data then will be display in the listbox.

example;
Combobox value is "Commune", "Client", "Year"
I choose column "Year" from combobox and enter "1958" in the textbox then when i click SEARCH button, all data regarding year 1958 will display in the listbox.

The problem is, when i choose "Commune" it give out error permission denied on line
And when i choose "Client" and "Year", nothing happen.. data is not filtered
This is my code, do you have any idea??

Please Login or Register  to view this content.

p/s: the listbox is filled with data source "myData"

[BadlySpelledBuoy]

Which line of code does the error happen on?

Can we see the file?

BSB

[blxckish]

Hai, sorry for the late reply. it give out error permission denied on line Me.ListBox1.AddItem
attached is my workbook ;