Close User Form By Clicking Elsewhere in Worksheet

[MikeG]

Is it possible to set a user form so that it closes when the user selects any cell in the worksheet? In other words the user form does not need to be closed by taking an action that involves the user form itself, such as click the X in the top right hand corner.

Hope that makes sense.

Thanks

 

[Jaafar Tribak]

Is it possible to set a user form so that it closes when the user selects any cell in the worksheet? In other words the user form does not need to be closed by taking an action that involves the user form itself, such as click the X in the top right hand corner.

Hope that makes sense.

Thanks

I guess you could use the selection change event as follows :

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

    On Error Resume Next
        Unload VBA.UserForms(0)
    On Error GoTo 0

End Sub

 

[Kenneth Hobson]

Be sure to show your userform modeless or set the showmodal property to false.

 

[MikeG]

Tyank you both.

MikeG