i am using the Combo and text box in my excel form, every time when i open the f

ID: 3562688 • Letter: I

Question

i am using the Combo and text box in my excel form, every time when i open the form using the the button click

Sub Sheet1_Button1_Click()
UserForm1.Show
End Sub

And when the form is opened i can't see any thing on the combo box, i can see them only after clicking some where on the screen.

i don't know why it is happening and later selecting that if i again click some where on the screen it is getting refreshed.

can we avoid this problem.

ComboBox2.Clear
With ComboBox2
.AddItem "First"
.AddItem "Second"
.AddItem "Third"
End With

Try to use a:

Private Sub UserForm_Initialize()

to load the items in the combo.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.