Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar updating
Hello, I hope someone can explain what the process Excel
uses to update a scrollbar. I have a scrollbar on a userform which is linked to a cell in a worksheet. The linked cell is part of a Index/Match formula such that when the scrollbar value changes the output of the Index/Match changes. The output of the Index/Match is linked to a textbox on the same userform. Therefore what should happen is when the scrollbar value changes the textbox should be updated. I have written some code into the scrollbar change event and found that unless I shift focus away from the scrollbar and then back again the update is missed?? Thanks in advance. TK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar updating
While I have not worked much with scrollbars, I have experienced very
similar problems with spinbuttons. Unfortunately, Excel's ActiveX controls are quite buggy. -- Vasant "T Kelly" wrote in message ... Hello, I hope someone can explain what the process Excel uses to update a scrollbar. I have a scrollbar on a userform which is linked to a cell in a worksheet. The linked cell is part of a Index/Match formula such that when the scrollbar value changes the output of the Index/Match changes. The output of the Index/Match is linked to a textbox on the same userform. Therefore what should happen is when the scrollbar value changes the textbox should be updated. I have written some code into the scrollbar change event and found that unless I shift focus away from the scrollbar and then back again the update is missed?? Thanks in advance. TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbar Help | Charts and Charting in Excel | |||
Scrollbar in charts | Charts and Charting in Excel | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
Formatting scrollbar | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) |