commandbutton to replace spinner

[RB Smissaert]

Looking at the best way to replace the Userform SpinButton.
There are a few troubles with them: No mousemove event, no good disabled
state.
Simplest would be to have 2 commandbuttons with up and down arrows.
In VB6 I can do this with the Marlett font and the letters t (for the up
image) and u (for the down image),
but this doesn't work in VBA userforms. The images just don't show.
Keep in mind that these spinners are quite small, 18 x 18.
Any suggestions who to do this best?

RBS

 

[Ikaabod]

If it were me I'd use V for down and /\ for up.

Looking at the best way to replace the Userform SpinButton.
There are a few troubles with them: No mousemove event, no good
disabled
state.
Simplest would be to have 2 commandbuttons with up and down arrows.
In VB6 I can do this with the Marlett font and the letters t (for the
up
image) and u (for the down image),
but this doesn't work in VBA userforms. The images just don't show.
Keep in mind that these spinners are quite small, 18 x 18.
Any suggestions who to do this best?

RBS

 

[RB Smissaert]

It doesn't look very nice.
Found a label with raised edges might do.
Just the positioning of the images isn't great.

RBS

 

[Ikaabod]

I just looked at my VBA in excel and the images you mentioned using the
font Marlett "u" and "t" showed up just fine for me. I'm using Excel
2003... I'm not sure if that makes the difference.

 

[RB Smissaert]

Got 2003 here as well, but what was your button size and font size?

RBS

 

[Ikaabod]

Height: 18
Width: 18
Font-Size: 8
Font: Marlett
Font-Style: Normal

lowercase: "u" = down arrow
lowercase: "t" = up arrow

 

[Ikaabod]

Font-Size: 10
also seems to work just fine (if not better)

-Height: 18
Width: 18
Font-Size: 8
Font: Marlett
Font-Style: Normal

lowercase: "u" = down arrow
lowercase: "t" = up arrow
-

 

[RB Smissaert]

The spinner is 18, but it will need 2 command buttons, so height of these
individual buttons will be 9 or 8.

RBS