online dating in miami - Vba status bar not updating

But if I run the macro at around 25% or 30% the Userform with the progress bar stops updating the bar and the progress seems like its stuck at that percent. The macro still runs fine and finishes without any errors.

I have to check deeper, but I think that I have other troubles in my macros with the new version of Excel!

This property returns False if Microsoft Excel has control of the status bar.

To restore the default status bar text, set the property to False; this works even if the status bar is hidden.

This example sets the status bar text to "Please be patient..." before it opens the workbook Large.xls, and then it restores the default text.

But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.

Status Bar = Format(fraction Done, "0%") & "done..." ' or, alternatively: ' status Range.value = Format(fraction Done, "0%") & "done..." ' Some code.......

but if anyone has already found a good solution, I'd be inclined to start building it into all of my loops that update the statusbar (and share it with my colleague :) Thanks!

Private Sub User Form_Activate() Dim d Time As Date Dim i, t As Integer For i = 1 To 100 Step 100 / 8 d Time = Now Time Value("") Application. Value = i Next i End Sub I have the code written so the progress bar shows the progress by taking the total number of loops that need to happen divided by the number of times the loop has taken place.

I think it has something to do with either Office 2016 or Windows 10.

Tags: , ,