jhnnyboz
06-05-2012, 12:43 PM
Hey I am just wonderign how to populate a activex combobox when the workbook is open.
I have tried clicking design and then clicking on the combobox and then view code (because it seems that this code is stored in a different place than a macro code is, because under view macros there is no code there)
and then my code is
Sub workbook_open()
ComboBox1.AddItem "Yes"
End Sub
but it does not populate the combobox when its open. I have also tried creating a macro and putting
Sub workbook_open()
ComboBox1.AddItem "Yes"
End Sub
in but it still does not populate. It will if under the code i hit run then it populates.
So i am just wonderign why this code is not wanting to run when the workbook is open.
Thansk
I have tried clicking design and then clicking on the combobox and then view code (because it seems that this code is stored in a different place than a macro code is, because under view macros there is no code there)
and then my code is
Sub workbook_open()
ComboBox1.AddItem "Yes"
End Sub
but it does not populate the combobox when its open. I have also tried creating a macro and putting
Sub workbook_open()
ComboBox1.AddItem "Yes"
End Sub
in but it still does not populate. It will if under the code i hit run then it populates.
So i am just wonderign why this code is not wanting to run when the workbook is open.
Thansk