Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Problems
Hello,
I'm having some issues with a combobox. I am using a combobox in a userform, to give the users options to choose, but also give them the ability to type in their own selection. The code I have is he Private Sub Contract1_Enter() ComboBox1.DropDown ComboBox1.AddItem "Option 1" ComboBox1.AddItem "Option 2" ComboBox1.AddItem "Option 3" ComboBox1.AddItem "Option 4" 'Use drop-down list ComboBox1.Style = fmStyleDropDownCombo 'Combo box values are ListIndex values ComboBox1.BoundColumn = 0 'Set combo box to first entry ComboBox1.ListIndex = 0 End Sub The problems I'm having are two. When I run the form for testing, it will only show me one option at a time, and I have to scroll down to get the others. Also, it gives me a horizontal scroll bar, which I don't want showing. Any ideas the properties, I'm missing to get this to look right? As you can see I'm using the Enter event, since the Initialize event did not seem to work. Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Problems
try listbox
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox problems !! | Excel Programming | |||
Having problems with adding input from combobox | Excel Programming | |||
Combobox Visibility Problems | Excel Programming | |||
ComboBox Problems | Excel Programming | |||
Combobox control problems in a grouped cell | Excel Programming |