Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Set Excel ScreenUpdating from ComboBox event
I am using several Combo Boxes on a workbook to set views for a data
table and chart. I am close to being done with this project, however, I'm trying to eliminate some screen flicker... The Application.ScreenUpdating = False attempt at line 3 doesn't cause any errors, but it doesn't change the property of Excel either. If I step into the code in break mode, nothing happens either. However in break mode, if I type the line into the immediate pane, the property changes. Has anyone seen this happen before? I can't determine if it is by design or simply some sort of bug this workbook is going through... Current project references a VBA MS Excel 11.0 OLE Automation MS Office 11.0 MS Forms 2.0 Example Code: Private Sub cmb_Element_Click() If c_call Then Exit Sub Application.ScreenUpdating = False Call ReplaceTarget Call TargetChart_Range Me.cmb_TimePeriod.Visible = True Me.cmb_Paper.Visible = True If Me.cmb_Element.List(Me.cmb_Element.ListCount - 1, 0) = "<Select Element" Then Me.cmb_Element.RemoveItem Me.cmb_Element.ListCount - 1 End If Application.ScreenUpdating = True Me.Range("C35").Select End Sub Thanks for any help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Set Excel ScreenUpdating from ComboBox event
On Apr 8, 12:09*pm, wrote:
I am using several Combo Boxes on a workbook to set views for a data table and chart. *I am close to being done with this project, however, I'm trying to eliminate some screen flicker... The Application.ScreenUpdating = False attempt at line 3 doesn't cause any errors, but it doesn't change the property of Excel either. *If I step into the code in break mode, nothing happens either. *However in break mode, if I type the line into the immediate pane, the property changes. Has anyone seen this happen before? * I can't determine if it is by design or simply some sort of bug this workbook is going through... Current project references a VBA MS Excel 11.0 OLE Automation MS Office 11.0 MS Forms 2.0 Example Code: Private Sub cmb_Element_Click() * *If c_call Then Exit Sub Application.ScreenUpdating = False * *Call ReplaceTarget * *Call TargetChart_Range * *Me.cmb_TimePeriod.Visible = True * *Me.cmb_Paper.Visible = True * *If Me.cmb_Element.List(Me.cmb_Element.ListCount - 1, 0) = "<Select Element" Then * * * * *Me.cmb_Element.RemoveItem Me.cmb_Element.ListCount - 1 * *End If Application.ScreenUpdating = True Me.Range("C35").Select End Sub Thanks for any help! Private Sub cmb_Element_Click() If c_call Then Exit Sub End If etc .... What's c_call? Should that be "If c_call = True Then " ... Don't know if this is the problem, but it might be :P Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Set Excel ScreenUpdating from ComboBox event
c_call is a global boolean variable I use to prevent activation of
combo box events when running other procedures. so no, it doesn't have anything to do with this issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an AfterUpdate event for excel combobox? | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Unable to Start Excel Event ID 2001 | Excel Discussion (Misc queries) | |||
unable to get the excel app event trigger for for window resize | Excel Programming | |||
unable to control screenupdating | Excel Programming |