View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dusan Dusan is offline
external usenet poster
 
Posts: 10
Default ScrollBar1_Change() problem

Hi there,

I use several scrollbars in my excel application and my problem is
following:
I do some calculation when any scrollbar value is changed by writing a
ScrollBar_Change()
procedure. It works fine when I use "step up/down" buttons ... but when I
change to different
ScrollBar e.g. ScrollBar2 (before I used ScrollBar1) and I select the middle
square (or slider?) and move
the slider the procedure ScrollBar_Change() is not called. If I move the
same slider one more time it works.
This happens just very first time when scroll bar is changed. It seams that
scroll bar needs to be selected first.

For up/down buttons it works straight away after changing scroll bars.

Any idea how to solve this?
Thanks
Dusan