Dear All Hi,
Hope all of you are safe from the Covid19 Pandemic.
Mean while, I have been struggling for hours to try and solve this issue. It's not consistent, but the combobox get's activated very now and then when I am doing something else.
I tried going through several threads in here but couldn't figure-out the solution as I am not any good at VBA.
I got the sheet done with the help of below thread and I realized reading some of the threads here that the issue is something to do with "ListFillRange", but got no clue to sort it by myself.
https://www.extendoffice.com/d…rop-down-list-search.html
Any help would be highly appreciated.
Attached is my File.
Thanks.