excel vba - Reopen a UserForm -

i have been stuggling same time don't how that...

when select cell in column q, userform (which ok).

in userform have content of selected cell (e.g. q6) (which ok)

in userform have 2 buttons: - quit: closes userform without saving text in cell; - save: save text in cell userform.

both @ saving , quitting selections (focus) remain on cell (q6).

i want when click again on q6 (witch selected), userform reopen again.

the solution found far, change selection (for exemple on p6).

cam anyone, please, me? thx.

in addition how showing form, add double-click event handler. in sheet's code module this:

private sub worksheet_beforedoubleclick(byval target range, cancel boolean)     if target.column = range("q1").column         userform1.show         cancel = true     end if end sub 

instruct users if want reshow form, should double click on selected cell.