Dropdown Width

[aftamath77]

Is there code for Visual Basics to control the width of the dropdown list for
combobox's. The list is °F and °C, which are very short widths, but the
dropdown width is too large by default. A lot od wasted space.

 

[Pete_UK]

Perhaps this link may be of use to you:

http://www.contextures.com/xlDataVal10.html#ChangeProp

Hope this helps.

Pete

 

[aftamath77]

I'm not using data validation. This is visual basic code.

 

[DS-NTE]

The macro-recorder is your friend. Record a macro when you adjust the width
of the combobox.
Example:

Sub Makro1()
'
' Makro1 Makro
' Makro registrert 06.10.2008 av driftsentral
'

'
ActiveSheet.Shapes("ComboBox1").Select
Selection.ShapeRange.ScaleWidth 0.50, msoFalse, msoScaleFromTopLeft
End Sub

Tidy it up afterwards.

HTH
knut