Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update scrollbar in code without causing change event
I have a number of scrollbars embeded in a worksheet which have change
events associated with them to update a table and a chart based on the scrollbar values. However, I have a 'show me' demo for the user, showing the scrollbar moving but I don't want the table and the chart to be automatically updated. Whenever I change the value of the scrollbar in my code, the scrollbar change event is triggered. Is there any way this can be turned off until the demo is finished? Any help most appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update scrollbar in code without causing change event
Have each change event check a "flag" before executing
For example: Private sub Scrollbar1_Change() if Worksheets("Hidden").Range("A1") = 1 then exit sub End Sub Then have your demo set Worksheets("Hidden").Range("A1") to 1 at the start and back to zero at the end. -- Regards, Tom Ogilvy "Sandra" wrote in message om... I have a number of scrollbars embeded in a worksheet which have change events associated with them to update a table and a chart based on the scrollbar values. However, I have a 'show me' demo for the user, showing the scrollbar moving but I don't want the table and the chart to be automatically updated. Whenever I change the value of the scrollbar in my code, the scrollbar change event is triggered. Is there any way this can be turned off until the demo is finished? Any help most appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update scrollbar in code without causing change event
Thanks for that - this was the only type of approach I could come up
with as well, so I presume it's not possible to 'turn off' change events for controls like scrollbars etc? If not, I'll go with the flag idea! Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update scrollbar in code without causing change event
No, it isn't provided for.
Application.EnableEvents is in the Excel object library. Scrollbars are in the MSForms object library, so EnableEvents doesn't affect them. -- Regards, Tom Ogilvy wrote in message oups.com... Thanks for that - this was the only type of approach I could come up with as well, so I presume it's not possible to 'turn off' change events for controls like scrollbars etc? If not, I'll go with the flag idea! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell change event causing EXCEL to crash | Excel Worksheet Functions | |||
Scrollbar Change event | Excel Programming | |||
Scrollbar Change event | Excel Programming | |||
change event/after update event?? | Excel Programming | |||
Click event on Scrollbar | Excel Programming |