Combo DropDown List is moving after text selection

Hi,

I am new to VBA. I am trying to have suggested name in combobox. After the name selection, it kept moving in all the sheets. Below are the VBA codes.
I added the ComboBox1_Close() to avoide this but still not working. Please refer to attachment.

Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDwnMemberList"
Me.ComboBox1.DropDown
End Sub

Private Sub ComboBox1_Close()
Me.ComboBox1.DropDown = ""
End Sub

Can anyone assist. Thank you.

Hi,

Each time I reopen the file, the vba codes I set as above goes missing and rekey in again and again. I retrieve the templates of the sample vba codes which is saved in xls format, the codes still remain but I don't understand why it goes missing.

Can anyone assist me? Thank you.

Don't use ActiveX controls on worksheets, rather use Forms Controls - they're in the same place, buch much more stable.

Also, why have you uploaded a picture in a word file? You could have attached the photo, or even better uploaded your workbook

If I use the Form Controls, I am not sure how the user is able to key in suggested name instead of scrolling down to find the name. It's time consuming. There are 200++ names in the list. How does VBA applies using the Form Controls, if I would like to use the suggested name?

And each time I reopen the file, the vba code is missing. I have been testing this for almost 2 days. I have uploaded the test data to have a clear picture.

Please assist.

It's missing because you are saving the file as xlsx...

I have tested by saving as xlsm format, the vba code exists. But the dropdown list is still moving in all the worksheet whenever I move the cursor after I reopen the file. Should I have add vba codes to clear the Combobox after I open the file?

Please advise.

Hi

I have solved it using a list box. This way it will be easier for the users to just click on the name instead of guessing.
Thank you for your contribution.