autohide userform with active sheet modification

[amrane]

dear forum,

I am looking to you help for the below problem,..

I do make some UserForm to make easy some analysis in the first sheet, but I don't like to keep them visible (loaded) when the user change the active sheet,

I didn't found the key instruction to auto-hide UserForm based on active sheet modification, so can you help,...

Amrane

[mana]

Private Sub Worksheet_Change(ByVal Target As Range)

[SamT]

Private Sub Worksheet_Activate()
UserForm_sheet1.Show vbModeless
End Sub

Private Sub Worksheet_Deactivate()
Unload UserForm_sheet1
End Sub

[amrane]

Dear Mr mana Mr SamT

Thank you so much for your quick feedback,
its simply perfect

Br
Amrane