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

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