Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ahh - Repaing - that was what I needed. Thanks!
On Fri, 28 May 2010 23:28:01 -0700, OssieMac wrote: Hi, The following simple example worked OK using Repaint. However, if I inserted the following line inside the If/End If then it did not work. Me.Label1.Caption = i Private Sub CommandButton1_Click() Dim i As Long For i = 1 To 100000 Me.Label1.Caption = i If i Mod 1000 = 0 Then Me.Repaint End If Next i End Sub The following code did NOT work and I have no idea why. Private Sub CommandButton2_Click() Dim i As Long For i = 1 To 100000 If i Mod 1000 = 0 Then Me.Label1.Caption = i Me.Repaint End If Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modeless UserForm doesn't show on Alt+Tab. | Excel Programming | |||
Modeless Form help please | Excel Programming | |||
Show Modeless Form | Excel Programming | |||
How to display a form- to show status of the running program | Excel Discussion (Misc queries) | |||
Modeless but waiting form | Excel Programming |