Dropdown list for ComboBox
Solved
JO
-
JO -
JO -
Hello,
A problem that I cannot solve. I created a ComboBox associated with the following code:
Sub ComboBox1_Change()
ComboBox1.List = Array("ok1", "ok2", "ok3")
End Sub
After launching my Excel file, I click on the arrow of the combo and no list appears.
I have to enter the input field, type a letter or a space, then click
on the arrow for the list to finally display!
What should I do or modify?
Thank you.
A problem that I cannot solve. I created a ComboBox associated with the following code:
Sub ComboBox1_Change()
ComboBox1.List = Array("ok1", "ok2", "ok3")
End Sub
After launching my Excel file, I click on the arrow of the combo and no list appears.
I have to enter the input field, type a letter or a space, then click
on the arrow for the list to finally display!
What should I do or modify?
Thank you.
3 answers
Hello,
it's normal that there is nothing since the values are loaded into the combobox at the time of its modification [Sub ComboBox1_Change()]
to have the values in the combobox as soon as the workbook is opened, you need to move the code. Where? It depends on your workbook (userform.........), the type of combobox...
See you later!
it's normal that there is nothing since the values are loaded into the combobox at the time of its modification [Sub ComboBox1_Change()]
to have the values in the combobox as soon as the workbook is opened, you need to move the code. Where? It depends on your workbook (userform.........), the type of combobox...
See you later!