sizing in Drop Down lists

[Banker]

I have attached drop down lists to a cell on my worksheet. The items in the
list are wider than the cell that it will be viewed in. I know I can format
the actual cell to wrap the text if it needs to for viewing after selected
but how can I VIEW the entire width needed in the drop down list when I click
on the arrow to choose the item I wish to show?? Basically I can only read
about half of each of the items in the list. I hope this makes sense.

 

[T. Valko]

You have to widen the column.

 

[Banker]

Sorry T. Valko, When I pull up your response the screen is blank. Can you
please try again???

 

[T. Valko]

You have to widen the column.

 

[Banker]

I was hoping there was another way. Thanks for your response.

 

[Gord Dibben]

Debra Dalgleish has written event code to temporarily widen the column when
the DV dropdown is selected.

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

Assumes DV dropdowns are in column D. If you want a specific or reduced
range post back.

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste the above into that module. Alt + q to return to the Excel
window.


Gord Dibben MS Excel MVP

 

[Banker]

Yes I found that same code on that website. Thanks for responding.