Changing spinbutton colors independantly or creating a custom one.

Hi Fran蔞is,

See the attached file which creates Faux two independent grouped shapes that look like your picture.

The following instructions for creating the shapes are included in the file:
a. Create a Forms CommandButton or any Shape of your Choice. Remove text from the Shape if needed.
b. Create an AutoShape Triangle. Fill the triangle with the appropriate color. Rotate the triangle if needed.
c. Place the triangle inside the CommandButton. Change the shape sizes as required.
d. Right Click the First Shape and Select Order > Send to Back. This will make sure the Triangle is always visible.
e. Left Click the First Shape. Press the CTRL key and Left Click the Triangle.
f. Right Click the Green Circle on the Triangle and Select Grouping > Group.
g. Rename the Grouped Shape to 'Group1SpinUp' or any name of your choice.
To rename the grouped shape, 'Right Click' the grouped shape. Press ALT F8 to make the Macro menu visible. 'Double Click' on 'RenameActiveShape'.
h. 'Right Click' the Grouped Shape and Select 'Assign Macro'. 'Double Click' on Group1SpinUpEventHandler or any existing macro of your choice.

i. Create 'Group1SpinDown' Shape using macro 'Group1SpinDownEventHandler' in a similar manner.

This should help you get started.
If you need additional help, more information is needed such as:
a. The number of SpinButtons you need. If you have a lot of SpinButtons, the event handler code can be made that only one Event Handler is needed to process any SpinButton event.
b. What the SpinButtons are supposed to do (codewise).

Lewis