Spinbutton Control

Hey Guys,

I have spinbutton control and it is working almost perfect.

the problem is that when I click the down or up button, it just sets focus on the controller and I must click up or down a second time then it works fine.

How do I set it up, so when I click the down up and down arrow it, sets the focus and spins in the same action?

below is my spincontroller code.

Anyhelp would be greatly appreciated.

Please Login or Register  to view this content.

Guys any luck on this?

Do I need to add a getfocus call on the spin up spin down???

Matt

When I test it on your workbook, I don't observe the same issue. It immediately goes to the next or previous record.

Maybe it is because I am using Excel Mac 2011?

That's a really good possibility.