Refreshing a form

[simoncpage]

hi all

How do I update/refresh a form automatically? for example

---------------------------------------
For Each sht In ActiveWorkbook.Sheets

frmHeader.lblsheetadd.Caption = "Sheet " & counter & " is being deleted"
counter = counter - 1

With sht.PageSetup
.LeftHeader = ""
.RightHeader = ""
.CenterHeader = ""
End With

Next sht

--------------------------------
how do i get the above to show the form counting down the sheets as all i see is a blank with the above

Thanks

Simon

 

[RobBroekhuis]

Is this code part of an event handler within the frmHeader code module?
Rob

 

[simoncpage]

Rob hi

The code is in the Userform_Activate() procedure (all in the form module).

thanks
Simon

 

[RobBroekhuis]

I think the problem may be that during the activate procedure, the userform is not yet officially "active". Not sure, though. You should need no explicit code to refresh a form - it should happen by itself. Just to test it, try to put your code in a different event handler (e.g. the click event for a temporary button) and see if it works for you then.
Rob