size of font in combo box

[organicjan]

I have set up a combo box, but the data is very small. How can I change the size of the data that appears in the combo box?
Thanks!

 

[organicjan]

Hi guys.

Thanks for your help, but it still is not working. After entering the stuff in the properties and closing those windows, the combo box still does not work. When I try to mouse over to the down arrow to get the list, I continue to get those Move arrows and I cannot use the drop down list.

I can send to you if you want to see.

Thanks,
Jan

 

[Andrew Poulsom]

Exit design mode by clicking the icon top left in the Control Toolbox.

 

[organicjan]

Thanks! I knew it had to be something simple! Now, my values are dates, but when I choose one it shows as a number...I have tried formating the cell reference, but it won't format to date.

 

[Andrew Poulsom]

In design mode right click the ComboBox and choose View Code. Add something like this:

Private Sub ComboBox1_Change()
    ComboBox1.Value = Format(ComboBox1.Value, "dd/mm/yy")
End Sub

Press Alt+F11 to return to your worksheet, then exit design mode and try it out.

 

[organicjan]

FABULOUS!!! Thanks so much!!!