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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.