Insert a 'pause' between VBA commands

[BRISBANEBOB]

I am trying to populate the data for a chart with a 'pause' between each command. It was possible in Lotus 1-2-3 but I don't know if there is an equivalent in VBA.

[sintek]

Please Login or Register  to view this content.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[BRISBANEBOB]

They both work a treat. Thank you. How do I get the chart to 'refresh' after the insertion of each value?

[sintek]

Not to sure what you mean...Currently the chart is updating as each value is populated

[BRISBANEBOB]

Hi Sintek

My chart doesn't populate until the macro has finished running. Neither of the two suggested solutions do. I must have a setting wrong somewhere. Any ideas where I should start looking?

Thank you for your assistance.

[sintek]

Add this snippet...

Please Login or Register  to view this content.

Also check your workbook calculation setting under Options|Formulas