Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple combobox with numbers:
Private Sub ComboBox7_DropButtonClick() ComboBox7.List = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10") End Sub I would like the "1" to appear as a default. I have tried but cant find anything for this! Thanks Mike |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Setting the Value property to "1" should do the trick. You can do this
through code or though the properties window. susan wrote: I have a simple combobox with numbers: Private Sub ComboBox7_DropButtonClick() ComboBox7.List = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10") End Sub I would like the "1" to appear as a default. I have tried but cant find anything for this! Thanks Mike |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Private Sub ComboBox7_DropButtonClick()
ComboBox7.List = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10") Combobox7.ListIndex = 0 End Sub But if you have other Combobox7 events, this might fire the event. -- Regards, Tom Ogilvy "susan" wrote: I have a simple combobox with numbers: Private Sub ComboBox7_DropButtonClick() ComboBox7.List = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10") End Sub I would like the "1" to appear as a default. I have tried but cant find anything for this! Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
select from combobox and show a price in textbox | New Users to Excel | |||
Selecting any cell in a column I want my ComboBox to show. How? | Excel Discussion (Misc queries) | |||
ComboBox to show a range | Excel Programming | |||
Show Filename Only in ComboBox Pulldown | Excel Discussion (Misc queries) | |||
Show one range in a combobox and write the 2nd range! | Excel Programming |