Form ComboBox problem

[cmpcwil2]

Finding numerous problems with carrying out tasks with the form comboBox
that are straight forward using the control combobox, here is m latest
problem...
Setting comboBox to display the first item in the list. I have
populated my forms comboBox with data when the workbook is loaded, I
have not used the input range property from right clicking the control.
I have then tried to set the comboBox to display the first item in the
comboBox using the following:

dim Ddown as DropDown
set Ddown = DropDowns("Drop Down 1")

Ddown.Text = myDD.List(1)

The problem I have now is that no matter what item i select from the
list it will not change and the value remains as the 1st item in the
list. Why does this happen with this type of comboBox and not the
control comboBox?

Thanks

 

[hewett_nick]

cmpcwil2,

Forgive me if I have misunderstood your problem. But as a quick
response off the top of my head try replacing...

Ddown.Text = myDD.List(1)

with...

Ddown.ListIndex = 1

HTH,
Nick.

 

[hewett_nick]

cmpcwil2,

Forgive me if I have misunderstood your problem. But as a quick
response off the top of my head try replacing...

Ddown.Text = myDD.List(1)

with...

Ddown.ListIndex = 1

HTH,
Nick.

 

[cmpcwil2]

Thank you works fine, why didn't I think of that!