Sub Test() With Sheet1.ScrollBar1 .LinkedCell = "Sheet1!A1" .Max = 1000 For i = 1 To .Max For j = 1 To 10 ^ 5 s = s + 1 Next j .Value = i DoEvents Next i End With End Sub
Sub Test() With Sheet1.ScrollBar1 .LinkedCell = "Sheet1!A1" .Max = 1000 For i = 1 To .Max For j = 1 To 10 ^ 5 s = s + 1 Next j .Value = i DoEvents Next i End With End Sub