Show Busy Mouse cursor while running the Macro

If you want to show busy status while macro is running. Try this code



Sub test()


' change mouse cursor to busy
Application.Cursor = xlWait

' Add your code


 change it back to normal
Application.Cursor = xlDefault

End Sub