View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default commandbutton to replace spinner

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