Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does one show an intital value in the combobox
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
|
|||
|
|||
How does one show an intital value in the combobox
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
|
|||
|
|||
How does one show an intital value in the combobox
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 | |
|
|
Similar Threads | ||||
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 |