Width of drop down lists

[Guest]

Does anyone if, when using a drop down list in a cell, it is possible to have the drop down box expand to the width of the widest entry in the list? They seem to be restricted to the width of the column.

 

[Debra Dalgleish]

You can use code to temporarily widen the list. There's sample code here:

http://www.contextures.com/xlDataVal08.html#Wider

 

[Guest]

Thanks Debra, but what you suggested, enlarges the entire spreadsheet. i wanted something that would just widen the dropdown list so that more character are visible, when everything is 'zoomed' its all the same.

 

[Debra Dalgleish]

Are you sure you used the code at the link that I suggested? In the
sample, it widens column 4 when a cell in that column is selected.

'=====================================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 4 Then
Columns(4).ColumnWidth = 20
Else
Columns(4).ColumnWidth = 5
End If
End Sub
'=========================================