Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selected item in combobox at DropButtonClick
On a userform I have a combobox with a number of integer numbers that are
years. On DropButtonClick I would like to have a certain item (the current year) selected and have that item at about the middle (height-wise) of the combobox. The combobox is populated like this: For i = 1 To 111 arrYears(i) = Year(Date) - (101 - i) Next i With ComboBox1 .List = arrYears .ListIndex = 100 .ListWidth = 48 .ColumnWidths = 48 End With How could I do this without using SendKeys or the Windows API? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
UserForm Combobox DropButtonClick Event Bug? | Excel Programming | |||
use selected value from one combobox to populate another combobox | Excel Programming | |||
ComboBox fails when last item selected first | Excel Programming |