How to setfocus back to userform, after data input to cell, Confusing here

Hi All,

Need help, to make the focus back to the userform after (I'll explained the step)
1. there's list of items where it taken from column L & M, displayed by listview in userform
2. the listview then detect which need to be bold & not (by value Y or N) with Vlookup
3. the user then doubleclick to copy the selected data from listview to designated area (within D2:D24, pink area)

this is where the focus problem occured
4. if the user double click the bold item, it'll command msgbox "please select the one not bold" > it'll focus on the selected cell on the sheet, after press ok in msgbox, not focus on userform
5. if the user double click the regular item, it'll input on selected cell > and STILL focus on the userform

weird....

if I change the code just to fill the cell with "", and not showing msgbox > the focus still on userform.

any idea to still use msgbox, and keep the focus on userform?

Floatinguserformmenulist.JPG

here's the code
on worksheet change

Please Login or Register  to view this content.

on Double click event

Please Login or Register  to view this content.

on Userform

Please Login or Register  to view this content.

Private sub for calling the list

Please Login or Register  to view this content.

thanks for the help

Hi,radian89
Try change Listview1 double click event like this

Please Login or Register  to view this content.