Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox.DropDown not working
Why does the Combobox not DropDown with the below?
If ComboBox2.Value < Sheets("References").Range("A2").Value Then ComboBox23.Enabled = False If ComboBox2.Value = Sheets("References").Range("A2").Value Then ComboBox23.Enabled = True ComboBox23.DropDown End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox.DropDown not working
Maybe the datatypes are different? If so, here's one way to work around:
If CStr(ComboBox2.Value) = CStr(Sheets("References").Range("A2").Value) Then -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "Corey ...." wrote in message ... Why does the Combobox not DropDown with the below? If ComboBox2.Value < Sheets("References").Range("A2").Value Then ComboBox23.Enabled = False If ComboBox2.Value = Sheets("References").Range("A2").Value Then ComboBox23.Enabled = True ComboBox23.DropDown End If |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox.DropDown not working
Corey,
I don't know if you pasted the code straight from your program, but as it is it won't compile. You don't have an End If for your first If. It looks like it should really be an If Then Else construct. hth, Doug "Corey ...." wrote in message ... Why does the Combobox not DropDown with the below? If ComboBox2.Value < Sheets("References").Range("A2").Value Then ComboBox23.Enabled = False If ComboBox2.Value = Sheets("References").Range("A2").Value Then ComboBox23.Enabled = True ComboBox23.DropDown End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox dropdown list? | Excel Discussion (Misc queries) | |||
combobox dropdown | Excel Programming | |||
Combobox Dropdown method | Excel Programming | |||
USE OF DROPDOWN in Combobox-a problem | Excel Programming | |||
ComboBox DropDown when Key is pressed | Excel Programming |