If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sizing in Drop Down lists
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. |
#2
|
|||
|
|||
sizing in Drop Down lists
You have to widen the column.
-- Biff Microsoft Excel MVP "Banker" wrote in message ... 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. |
#3
|
|||
|
|||
sizing in Drop Down lists
Sorry T. Valko, When I pull up your response the screen is blank. Can you
please try again??? "Banker" wrote: 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. |
#4
|
|||
|
|||
sizing in Drop Down lists
You have to widen the column.
-- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: 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. |
#5
|
|||
|
|||
sizing in Drop Down lists
I was hoping there was another way. Thanks for your response.
"T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: 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. |
#6
|
|||
|
|||
sizing in Drop Down lists
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 On Wed, 17 Jun 2009 10:21:02 -0700, Banker wrote: I was hoping there was another way. Thanks for your response. "T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: 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. |
#7
|
|||
|
|||
sizing in Drop Down lists
Yes I found that same code on that website. Thanks for responding.
"Gord Dibben" wrote: 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 On Wed, 17 Jun 2009 10:21:02 -0700, Banker wrote: I was hoping there was another way. Thanks for your response. "T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|