Combobx always lost his focus when i type in Combobox

hi,
i am filtering my data (Range("b4:b100") using combobx1 (in sheet not userform) = doing good

Please Login or Register  to view this content.

Please Login or Register  to view this content.

now i want to select visible cell from Filtered data of Range("a4:a100")

Please Login or Register  to view this content.

and if i add this code to my filter code

Please Login or Register  to view this content.

now combobox1 is losing focus

hope some one will help

It's merely logic that when shifting focus to another object (worksheet in this case) that your Combo loses focus.
Is it really needed to select the filtered range ? What do you want to do with it ?

I want to highlight the visible row of filtered data
like this

Please Login or Register  to view this content.

Actually i want to run this macro when i press enter in combobox1 and after this combobox1 should be selected...

Please Login or Register  to view this content.

Sorry for delay, but this should do it.

Please Login or Register  to view this content.