Give Excel Some Time to load PALO and calculate Workbook

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Give Excel Some Time to load PALO and calculate Workbook

    Hi 2all,
    got some annoying issues concerning Excel / VBA and PALO. When e.g trying to fill some controls with Elements (toggled by workbook open event) I got errors because PALO has not finished starting yet or excel calculation has not finsihed yet. So I needed a way to make excel do what ever it wants to do for a few seconds and continue my coding afterwards. This is what I found:

    Place This in your workbook open event to give Excel 4 seconds for whatever

    Application.OnTime now + TimeValue("0:0:4"), "MyProcedureNameToContinueWith"

    Works well....even better than DoEvents :)

    Greetings from Cologne
    Holger