| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
If it were me I'd use V for down and /\ for up. RB Smissaert Wrote: 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 ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
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" wrote in message ... If it were me I'd use V for down and /\ for up. RB Smissaert Wrote: 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 ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
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 Wrote: 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" wrote in message ... If it were me I'd use V for down and /\ for up. RB Smissaert Wrote: 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 ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
Got 2003 here as well, but what was your button size and font size?
RBS "Ikaabod" wrote in message ... 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 Wrote: 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" wrote in message ... If it were me I'd use V for down and /\ for up. RB Smissaert Wrote: 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 ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
Height: 18 Width: 18 Font-Size: 8 Font: Marlett Font-Style: Normal lowercase: "u" = down arrow lowercase: "t" = up arrow RB Smissaert Wrote: Got 2003 here as well, but what was your button size and font size? RB -- Ikaabo ----------------------------------------------------------------------- Ikaabod's Profile: http://www.excelforum.com/member.php...fo&userid=3337 View this thread: http://www.excelforum.com/showthread.php?threadid=54065 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
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 - -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
commandbutton to replace spinner
The spinner is 18, but it will need 2 command buttons, so height of these
individual buttons will be 9 or 8. RBS "Ikaabod" wrote in message ... Height: 18 Width: 18 Font-Size: 8 Font: Marlett Font-Style: Normal lowercase: "u" = down arrow lowercase: "t" = up arrow RB Smissaert Wrote: Got 2003 here as well, but what was your button size and font size? RBS -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=540651 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum Value for Spinner | Excel Discussion (Misc queries) | |||
| Autofilter/Spinner | Excel Discussion (Misc queries) | |||
| Spinner | Excel Discussion (Misc queries) | |||
| Spinner | Excel Programming | |||
| Using Protection on a Spinner | Excel Programming | |||
Linear Mode
