Sub StatusBer() Dim L As Long For L = 1 To 10000 Range("A" & L) = L '----------ここに処理記入 Application.StatusBar = "実行中…" & String(Int(L / 1000), "■")'--1000毎に■を増やす Next L Application.StatusBar = False '---Falseでステークスバーの操作を戻す End Sub
Sub StatusBer2() Dim L As Long For L = 1 To 10000 Range("A" & L) = L '----------ここに処理記入 Application.StatusBar = L & "回目の処理を実行中!" Next L Application.StatusBar = False End Sub