Show UserForm when switch to a sheet Solved by : ?

hello evryone

i want to show my userform("UserForm1") when i goto sheets("sheet1")

when i select this form property of userform ,...... showmodel = false

i want here userform don't show on other sheets

e.g i want to popup userform on sheet1 and showmodel = false

then userform show only on sheet1 if i go to sheet2 then userform = hide


thanx a lot

Put code in Thisworkbook object.
It uses code name of Sheet1 rather than sheet tab name, but you can change that.

Please Login or Register  to view this content.