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.

Perhaps this link may be of use to you:

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

Hope this helps.

Pete

"aftamath77" wrote in message
...
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.

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

"Pete_UK" wrote:

Perhaps this link may be of use to you:

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

Hope this helps.

Pete

"aftamath77" wrote in message
...
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.

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

"aftamath77" skrev i melding
...
I'm not using data validation. This is visual basic code.

"Pete_UK" wrote:

Perhaps this link may be of use to you:

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

Hope this helps.

Pete

"aftamath77" wrote in message
...
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.