commandbutton to replace spinner

  • Thread starter Thread starter RB Smissaert
  • Start date Start date
R

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
 
If it were me I'd use V for down and /\ for up.

RB said:
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
Click to expand...
 
It doesn't look very nice.
Found a label with raised edges might do.
Just the positioning of the images isn't great.

RBS
 
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.
 
Height: 18
Width: 18
Font-Size: 8
Font: Marlett
Font-Style: Normal

lowercase: "u" = down arrow
lowercase: "t" = up arrow
 
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
-
 
The spinner is 18, but it will need 2 command buttons, so height of these
individual buttons will be 9 or 8.

RBS
 
Back
Top