I’ve been reading this again & looking at my form but don’t see an issue.The logic of your desired action is flawed.
At that point, the only entry in the userform would be the default entries. "if there are more than 1 name" would never change.
When the user opens the worksheet they are unaware if there is going to be 3 or 65 names in the userform drop down list.
The message box appears Would you like to open the userform. They select NO & the message box closes & they continue to work on the worksheet itself.
However if they had selected YES then the code should check how many names are in the drop down list BEFORE even thinking of opening the userform.
If there is 1 name or less then show message box No Namea etc, the message box closes & userform doesn’t open.
However if there are 2, 33 or 100 names then open userform.
I don’t see where the problem lies ???
Basically the code which we write will only open the userform if there are 2 or more names.
If they is 1 or less names then show message box with message etc.
What’s wrong with that please advise.