View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hughie hughie is offline
external usenet poster
 
Posts: 15
Default stopping userform resize on minimize

Using Stephen Bullen's form fun, I've got a form minimizing (huzzah!)
but the UserForm_Resize event is not exiting when it should. ie, the
line:

If Me.InsideWidth = 0 Then Exit Sub

doesn't have an InsideWidth of 0 during a minimize (nor does it seem to
in his frmTest, but it still works, it shouldn't!).

...anyone know the syntax for trapping a minimize event? I tried
application.windowstate but was getting -4143 in all cases.

Hughie