Application.wait not activating at correct point | Excel forum

Resolved · Low Priority · Version 2016

Fri 24 Nov 2017, 15:55 Delegate Phillip said...

Phillip has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course

Application.wait not activating at correct point

Hi,

I'm having a problem with application.wait in that the pause does not seem to be happening in the point of the code that the command is.

I was trying to use it so that an object showed at a certain point but below is a very basic data entry sub that is producing the same problem. When I run this code the pause happens after the word "this" appears and then after 5 seconds the other words appear but I want the pause to happen after "this" "is" "a" appears.

Sub PauseTest()

[a1] = "this"

[b1] = "is"

[c1] = "a"

Application.Wait Now + #12:00:05 AM#

[d1] = "test"

End Sub

Mon 27 Nov 2017, 10:35 Trainer Sarah said...

RE: application.wait not activating at correct point

Hi Phillip

Thanks so much for your question.

Our VBA trainers are all very busy training today, so to ensure you get the best answer possible we will have to delay our answer until tomorrow.

I hope this is ok.

Regards,

Sarah
Excel Trainer

Fri 1 Dec 2017, 10:51 Trainer Jens said...

RE: application.wait not activating at correct point

Hi Phillip,

I am sorry that you had to wait for the answer.

Sub PauseTest()

[a1] = "this"

[b1] = "is"

[c1] = "a"

Application.ScreenUpdating = True

Application.Wait Now + #12:00:05 AM#

[d1] = "test"

End Sub

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 6 Dec 2017, 10:49 Trainer Wendy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 14 Dec 2017, 10:22 Delegate Phillip said...

RE: application.wait not activating at correct point

excellent, thank you.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips