UserForm Combobox2 Loosing focus

[HaroonSid]

hi,
i am facing a problem here with same event...
if i popup Rate (userform )using command button

Please Login or Register  to view this content.

,then its loosing focus when i run this code

Please Login or Register  to view this content.

if i create a shortcut key to popup the Rate (userform) then its working smoothly

Please Login or Register  to view this content.

and now i run last blank row select code then combobxox2 is not loosing focus!!!

so the problem is with commandbutton2_click

[jonathann3891]

Your not using a modeless userform, so your macro that is selecting a range is forcing the userform to close.

Try this...

Please Login or Register  to view this content.