Use Application.DoEvent : Application DoEvent « Application « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Application » Application DoEvent 




Use Application.DoEvent
 
Sub UseApplicationDoEvent()
       StarWidth = 25
       StarHeight = 25
       
       Set NewStar = ActiveSheet.Shapes.AddShape(msoShape4pointStar, LeftPos, TopPos, StarWidth, StarHeight)
       NewStar.Fill.ForeColor.SchemeColor = Int(Rnd() 56)
       Application.Wait Now + TimeValue("00:00:01")
       DoEvents
       Application.Wait Now + TimeValue("00:00:02")
End Sub

 














Related examples in the same category
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.