Hello Everyone,<o></o>
<o> </o>
Can someone please help me to resolve this issues.<o></o>
<o> </o>
I have been getting the Runtime error '13' type mismatch.<o></o>
Please try this process to get the error message and youwill know what I meant.
1st – Go to the userform and Select any item in listbox1 and click"OK" and then return to textbox1 to select a new item that is
when you get the error message "runtime error 13".
2nd: "CLEAR ENTRY" is not working, the message error
appear "runtime error 13" after you click OK button to start a newentry.<o></o>
<o> </o>
3rd – the last one is that I am not able touse textbox1 to select from the listbox1 when my sheet2 (agency) isunprotected. I need to protect sheet(agency) to avoid someone to mess up my list.<o></o>
Here is the file:
https://www.dropbox.com/s/sdmn4aww2116848/SEARCHFILTERLISTBOX_ERRORMSG.xlsm?dl=0
If you can please fix this issues for me. Greatly appreciated. Thank you. <o></o>
<o> </o>
Can someone please help me to resolve this issues.<o></o>
<o> </o>
I have been getting the Runtime error '13' type mismatch.<o></o>
Please try this process to get the error message and youwill know what I meant.
1st – Go to the userform and Select any item in listbox1 and click"OK" and then return to textbox1 to select a new item that is
when you get the error message "runtime error 13".
2nd: "CLEAR ENTRY" is not working, the message error
appear "runtime error 13" after you click OK button to start a newentry.<o></o>
<o> </o>
3rd – the last one is that I am not able touse textbox1 to select from the listbox1 when my sheet2 (agency) isunprotected. I need to protect sheet(agency) to avoid someone to mess up my list.<o></o>
Here is the file:
https://www.dropbox.com/s/sdmn4aww2116848/SEARCHFILTERLISTBOX_ERRORMSG.xlsm?dl=0
If you can please fix this issues for me. Greatly appreciated. Thank you. <o></o>