T
T Kelly
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
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