Tuesday, February 21, 2012

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

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...