PDA

View Full Version : Solved: Extended 'ControlTiptext' for combobox items



lifeson
09-18-2007, 05:09 AM
I have a combo box which fits nicely on my userform but doesnt always show the full description of the item as you go down the list
Is there a way to show the full description of the item highlighted in the controltiptext box?

Bob Phillips
09-18-2007, 05:45 AM
Seems to work, but you do need to move the mouse to get it



Private Sub ComboBox1_Click()
Dim i As Long
With Me.ComboBox1
.ControlTipText = .Value '.List(i - 1)
End With
End Sub

lifeson
09-18-2007, 06:03 AM
I was thinking more about showing the value when the mouse highlights an item in the drop down list whilst the dropbutton is clicked

Andy Pope
09-20-2007, 04:13 AM
Try the ListWidth property. This controls the width of the dropdown section of the control.

Also you may need to play with the ColumnWidths property is the content of a column is longer than the defaul width.

lifeson
09-20-2007, 09:40 AM
Try the ListWidth property. This controls the width of the dropdown section of the control.

Also you may need to play with the ColumnWidths property is the content of a column is longer than the defaul width.

Cheers for the tip Andy, I didn't realise the column width when dropped could be wider thah the combobox itself
:thumb