Width of drop down lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
'=========================================
 
Back
Top