TEmporarily stop code in VBA
Posted on 2012-04-02
I have a process taht I want to hesitate for about two seconds before proceeding. But how would I do that? That is, Between two lines below, I want the VBA to hestitate before proceeding.
Me.cmdCAR.BackColor = 2858687
'Hesitate here to allow time for the backcolor change on the form
intCount = DCount("UserID", "TblUsers_CAR", "UserID = '" & gstrUserID & "' AND Active = -1 ")