Combobox.DropDown not working

C

Corey ....

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
 
T

Tim Zych

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
 
D

Doug Glancy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating Combobox Methods 10
initialize userform, using a sub 11
Identify what Combobox was changed to update the correct item on the previous Form 2
Type mismatch error only on the first run 2
Delete Entire Row 4
Printing range on combox criteria? 2
ComboBox.visible = False or True 7
Basic Stuff to some 1

Top