LinkBack URL
About LinkBacks
How do I achive that a spin button only changes one when the button is pressed? i.e. the button shall be released and pressed again in order to be updated.
As it is now the value is keeps changing when the button is pressed.
How do I achive that a spin button only changes one when the button is pressed? i.e. the button shall be released and pressed again in order to be updated.
As it is now the value is keeps changing when the button is pressed.
Last edited by AliGW; 06-21-2020 at 05:46 AM.
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. As this is your first post, I have done it for you this time.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi torgny,
Are you using the 'Form Control' spin button (as opposed to the ActiveX). If so, in the Developer tab in the top ribbon, select ' Design Mode', then right-click on the spin button and select the 'Format Control' option. In the new dialog box, select 'Control'.
Here you can change the behaviour of the button, including the incremental change.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
Im using an ActiveX button goes from -100 to 100 increment 1.
Thats fine but my problem is that when i press the button i have to release it very quickly if not it keeps updating.
I want it to just update one time each time i klick on it regardless of how long i press the button.
For ActiveX, make sure you are in Design Mode, right-click on the Spin Button and select Properties.
There is a setting for 'Delay'. Change it to 99999.
Thank you just what i wanted to achieve.
You are welcome.
If this answered your question, please take the time to mark this thread as SOLVED. You can do this at the top under Thread Tools.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks