endless loop

Hi all, My problem is; that the code works like a charm, no run-time errors or any of the sorts, there is error handling in my code with user-forms (with simple input-boxes it was confusing) they work great too, except in the last row instead of my loop ending, it runs over to the next row and...

Frequently when I am entering code in VBA, I will execute the code. But if I inadvertently created an endless loop sometimes my screens will go tinted white and I cannot interrupt the code. How can I stop the code without having to lose all my latest work? If I remember, I will add a doevents...

Private Sub UserForm_Initialize() Dim myWorksheet As Worksheet With lstSheets .MultiSelect = fmMultiSelectMulti .ListStyle = fmListStyleOption For Each myWorksheet In Worksheets If myWorksheet.Visible = xlSheetVisible Then 'add each...

I have a multi-sheet workbook. The first sheet is a summary of results from the rest of the workbook. I would like this summary sheet to auto-refresh itself each time the sheet is activated. The VBA code triggered by the Worksheet/Activate event feeds some parameters out to other sheets, then...