Excel Userform- restrict users to choose from a drop down

[PANTECH]

Please provide the code to restrict users from altering "cboInitials". Will also need a message box to pop up stating "Restricted entry, please select from the dropdown". They should not be able to proceed until this has been completed. Below is the current code......

Please Login or Register  to view this content.

[Norie]

You would need code to alter the combobox, and I don't see any that'll do that in what you've posted.

To ensure the user has selected (or typed) an item from the list check the combobox's ListIndex property on Exit.

Please Login or Register  to view this content.

[PANTECH]

This almost had it. The problem now is that when I click "Save" it clears all fields except "Initials" and won't let me leave that record. Please tell me what I did wrong!

Please Login or Register  to view this content.

[Norie]

It's not really a good idea to post the entire code every time.

Probably best to upload a workbook with the latest code.

[Norie]

I would post a solution but I don't have time to reconstruct the userform which I would need to do for testing.