spinbutton not take focus?

S

Sandy

I'm using 2002. In a userform, I've got the funcionality of a spinbutton
working right, but it takes focus on click, creating a focus outline around
the arrows on the up and down buttons. I don't care for the look of that.

Is there a way to force a spinbutton to NOT take focus? I don't see it in
the properties and have unsuccessfully tried some code on click or change to
set focus elsewhere.

Thanks, Sandy.
 
B

Bill Dilworth

Hi Sandy,

The problem is that the spin button can not be pressed without having the
focus, so by changing the focus to another object after it is
pressed/changed, you 1) remove the repeating ability of it, and 2) require
that the up or down button be pressed twice to make it work again.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
yahoo2@ Please read the PowerPoint
yahoo. FAQ pages. They answer most
com of our questions.
www.pptfaq.com
..
..
 
S

Sandy

Thank, Bill. I understand the need for focus, but, still is there any clever
way to rid the spin arrows of the focus outline? Black box outlines appear
around the arrows, making them unrecognizable when the control is small.

Or, is that just the normal way it has to be?
 
B

Bill Dilworth

Not easily. You would need to directly access the mouse button state (via
API calls) while the cursor was over a false image of the spin button.

Of course I may be wrong, and if I am, I would hope someone would jump in
and correct me, but I do not believe that it can be done otherwise.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
yahoo2@ Please read the PowerPoint
yahoo. FAQ pages. They answer most
com of our questions.
www.pptfaq.com
..
..
 
S

Sandy

Thanks, Chirag. That does help because I didn't thank of faking in some
buttons. I'm pretty sure I can run with that idea. It seems I'll loose the
rapid fire feature, but I'm working with small numbers anyway, so it won't
matter. The look is more important.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top