Posts by nzso

Hi Guys,

Sorry for the Late Reply.

Had some stuff I had to take care of which didn't allow me to look into this matter.

rory

This time it somewhat gives a solution but not without a new catch.

When I start to type the Drop-Down opens up but doesn't get update then and there as I type in.

But let's say I got an agent name partially right,

If I stop typing it ( While the Drop-Down remains the same ) click another cell and try to continue type again,

Then the Drop-Down opens up with the updated set of Data.

Why is that?

@ All,

Any other work around or solutions guys?

@ Rory

- Professional Plus 2019.

@ Rory

Yeah... Same issue... Neither does it pick anything from the Drop down Narrowing it down, stays same for a while and then the error pops-up.

@ Rory

It's a Runtime Error-381

"Could not set the List properly. Invalid Property array Index.

That's what I am getting.

@ Rory

I did Clear the ListFillRange from the Properties and pasted your code below the respective Sheet and I am running towards an error when I debug it highlights the line No. 4

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.