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
Bookmarks