Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-26-2022, 11:35 PM
rollis13's Avatar
rollis13 rollis13 is offline How to show wait cursor during vba script? Windows 10 How to show wait cursor during vba script? Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 143
rollis13 will become famous soon enough
Default

Sorry, did some other testing, the 'wdCursorWait' that shows up is not the function in the macro but the default cursor used by Excel to show that it's working. So, what I said in my previous post is nonsense. This will show wait cursor too.
Code:
Sub test()
    Dim a
    ' Set status bar text
    StatusBar = ("Please wait...")
    ' Turn cursor to wait
    'System.Cursor = wdCursorWait                  '<- here (note that it isn't active)
    ' My script runs here...
    Do While a < 2001
        For a = 1 To 2000
            Selection.TypeText Text:="abc"
        Next a
    Loop
    ' Turn cursor back to normal.
    StatusBar = ("Complete")
    System.Cursor = wdCursorNormal
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cursor/typing caret doesn't show when moved around in Word 2019 vkhu Word 2 09-30-2020 07:58 AM
Wait (hourglass) cursor constantly flashing after loading large file didlinghill Word 4 01-26-2015 06:08 AM
How to show wait cursor during vba script? Wait for 2013? Warranty issue.... alexb123 Office 1 12-14-2012 01:44 PM
How to show wait cursor during vba script? Applicatin.wait SDondeti Word VBA 1 05-27-2011 02:12 AM
Show cursor in PP presentations whs PowerPoint 0 03-12-2011 11:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft