LinkBack URL
About LinkBacks
Hi, when I click spin button macro is executed, which adds 1 to "F1" Cell. But no mother how long I hold the spin button it executes macro only one time. Does anybody knows how to make it execute my macro as many times an iterations happend?
Hi, when I click spin button macro is executed, which adds 1 to "F1" Cell. But no mother how long I hold the spin button it executes macro only one time. Does anybody knows how to make it execute my macro as many times an iterations happend?
Use an ActiveX button instead of a Form button. The Form button only calls the macro on a click. The ActiveX has an event called Change that fires every time the value of the spin button changes, including when you are holding down the mouse button.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time to keep things moving. Please give it more thought in the future. --6StringJazzer
Thanks! I was aware of this fact, but I left title edition for the end and forgot about it. Thanks, anyway.
You have solved with that all my problems for the week. I thought I won't be able to change charts by holding a button, but it does it!
I'm very thankful. Have a nice day!
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks