Disable only SpinUp/SpinDown on a spin button

Hi all,

I suspect the answer to this will be no, but I'll ask anyway. I am using a Spin Button to move data up/down a list, and I have written some code (below) that identifies wheter or not the selected item is top/botom of the list. If it is, I would like to disable the option to spin up/down, but I can only find an option to disble the the button as a whole. Is there another option to do this or will I have to write some code to stop it working in these situations.

Thanks.

The code that I use to identify options on the top/bottom of the list. This Macro is activated by an _change event on the UserForm.

Please Login or Register  to view this content.

You can't disable part of a spinner (well, you probably could with some really complex API functions) - normally you would just check the max if you are spinning up or the min if spinning down and issue a warning as applicable.

Thats a shame, would be so much easier if I could! Thanks anyway.