Customized spin button
 

Hi,

I am trying to customize several spin buttons ( control toolbox ) for
worksheet simulations.
With the idea of having two different Forecolors (green and red) as
well as rotated arrows, I though of using transparency ...
Unfortunately, the BackStyle property doesn't appear to be available
for spin buttons ...
Could this property be programmatically added to this OLEObject ?
....and how ?

TIA
Cheers
Carim

Customized spin button
 

Hello Carim,

To add the property would require re-writing the SpinButton class in
C++. An Easier solution is to make 2 command buttons and place them
side by side. Change the Picture property to an arrow (left, right, up,
or down). It means writting a little more code, but it gets the job
done.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494324

Customized spin button
 

Hi Leith,

Thanks for your suggestion. I will follow it ...
Rewriting the SpinButton class in C++ is way beyond my competence ...
Cheers
Carim