Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar macros
I want to use scrollbars to change the speed of some MIDI things that
are being played using the new midiprocessing ocx controls available from Sourceforge. I need a macro which fires when a scrollbar handle is moved, not only when it is release, since I want to change speed continually. I have been totally unsuccessful with the scrollbar from the Control toolbox, the Scrollbar_Change macro is not even executed while another macro is running. The macro associated with a scrollbar from the Forms toolbox works, but only when I release the scrollbar handle, not while I am moving it. It behaves like it were a modal object, and I would like the scrollbar to be modeless. Can it be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar macros
Hi
With a scrollbar from the controls toolbox onto a worksheet, these two works fine here. "Scroll" is the event that fires on scrolling. THis code goes in the worksheet module (rightclick the scrollbar, go "view code" to get to the right place). Private Sub ScrollBar1_Change() Cells(1, 1).Value = ScrollBar1.Value Cells(1, 2).Value = "change" End Sub Private Sub ScrollBar1_Scroll() Cells(1, 1).Value = ScrollBar1.Value Cells(1, 2).Value = "scroll" End Sub So question is what your "another macro" does and if you can reorganize the code if it conflicts. HTH. Best wishes Harald "Erich Neuwirth" skrev i melding ... I want to use scrollbars to change the speed of some MIDI things that are being played using the new midiprocessing ocx controls available from Sourceforge. I need a macro which fires when a scrollbar handle is moved, not only when it is release, since I want to change speed continually. I have been totally unsuccessful with the scrollbar from the Control toolbox, the Scrollbar_Change macro is not even executed while another macro is running. The macro associated with a scrollbar from the Forms toolbox works, but only when I release the scrollbar handle, not while I am moving it. It behaves like it were a modal object, and I would like the scrollbar to be modeless. Can it be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar macros
The Scroll event solved my problem.
Thank you. Harald Staff wrote: Hi With a scrollbar from the controls toolbox onto a worksheet, these two works fine here. "Scroll" is the event that fires on scrolling. THis code goes in the worksheet module (rightclick the scrollbar, go "view code" to get to the right place). Private Sub ScrollBar1_Change() Cells(1, 1).Value = ScrollBar1.Value Cells(1, 2).Value = "change" End Sub Private Sub ScrollBar1_Scroll() Cells(1, 1).Value = ScrollBar1.Value Cells(1, 2).Value = "scroll" End Sub So question is what your "another macro" does and if you can reorganize the code if it conflicts. HTH. Best wishes Harald "Erich Neuwirth" skrev i melding ... I want to use scrollbars to change the speed of some MIDI things that are being played using the new midiprocessing ocx controls available from Sourceforge. I need a macro which fires when a scrollbar handle is moved, not only when it is release, since I want to change speed continually. I have been totally unsuccessful with the scrollbar from the Control toolbox, the Scrollbar_Change macro is not even executed while another macro is running. The macro associated with a scrollbar from the Forms toolbox works, but only when I release the scrollbar handle, not while I am moving it. It behaves like it were a modal object, and I would like the scrollbar to be modeless. Can it be done? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar macros
Glad to hear that. Thanks for the feedback.
Best wishes Harald "Erich Neuwirth" skrev i melding ... The Scroll event solved my problem. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbar Help | Charts and Charting in Excel | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
Possible to Customize Scrollbar? | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Scrollbar | Excel Programming |