Spinbutton problems

[alathwell]

On clicking up or down on spinbutton control the On Update action does not not run.
Trying to inc/dec text box from spinbutton. I set a code break to check values but code is not being called, and I don't know why.

Any help please

alathwell

 

[boblarson]

It looks like you need the UpClick and DownClick events. However, those events aren't available from the properties window. You have to go to the code window and then use the event dropdown up on the top of the VBA window to select the appropriate event.

 

[alathwell]

Spinbutton

Thanks for your message.

And Thanks yes I found (eventually) where you suggested and works fine.

I would also like to browes for a file and select its pathname and place it in a text box. I have used the activex browse button. I cannont find any obvious commands that provide openfile type functionality. If you have any ideas that would be great.


Look forward your reply.

Regards
alalthwell