Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have the following code... Sub testInterActive() Dim x As Integer Application.Interactive = False For x = 1 To 10000 Range("C12").Value = x Next x MsgBox "Long procedure completed" Application.Interactive = True End Sub What happens is that whilst the long procedure is running and you happen to punch couple of keys followed by "Enter" key, at the end of the procedure those keys that you punched are recorded on to the sheet. PS keep punching couple of more times whilst the procedure is running and remember to press "Enter" after each punch attempt. The Msgbox also does not appear. Qn. What gives or is happening? And how do you prevent this? Many thks. Rgds KZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Visible = False | Setting up and Configuration of Excel | |||
Application.Visible = False | Excel Discussion (Misc queries) | |||
Application.Interactive=true ignored? | Excel Programming | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Application.screenUpdating = False | Excel Programming |