How do you change the size the arrow in a control combo box ?

[RamblinWreck]

Hello again:

Given the quick success that I had yesterday on getting an answe
regarding a combo box from the controls toolbar, I thought that I woul
try again.

The problem this time is that I want to increase the size of th
arrowhead on the controls combo box. It really looks pretty bad righ
now on the spreadsheet (much more like a dot rather than a
arrowhead).

I looked for the combo box property that governs arrowhead size, but
could not find one.

Many thanks

 

[Karl]

Dont think you can but you could if you need it bigger but a command button
on top and do

Private Sub CommandButton1_Click()
ComboBox1.DropDown
End Sub

just need to find a font with the down arrow and you can have it as big as
you want

Regards

Karl

 

[RamblinWreck]

Karl:

Many thanks for your suggestion. A simple variant of your suggestio
worked like a champ ! I tried using a font (the symbol font to b
exact), but the arrow wouldn't center correctly when I made the comman
button small so that it would fit over the existing arrow in the dro
down box.

Instead of a font-based arrrow, I just created an arrow in MS-Paint
saved this arrow as bitmap, then imported the bitmap into the comman
button as picture under the picture properties of the command button.


I placed the command button and the over the existing arrow of th
combo box, and I then grouped the combo-box and the command butto
together using the "group" command from the draw toolbar. Everythin
has worked great so far !

Again, many thanks for your idea.

[PS - Go Jackets !!