If you turn the mouse pointer into an hourglass (and back to normal) in a routine with error handling, don’t forget to turn the mouse pointer back to normal in the error-handler section. Otherwise, the program might look busy, but actually be done:
Private Function CalcTotal() As Long On Error GoTo ProcErr Screen.MousePointer = vbHourglass ' 'Code that may raise error ' Screen.MousePointer = vbNormal Exit Function 'Don't go into error handlerProcErr: Screen.MousePointer = vbNormal ' 'Error handling code 'End Function
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
