Hello,
I have a list box on a user form that is populated with several sheet names.
If you don't select anything on the list, I want to send a message to the
user that he didn't select a sheet. I have one list box where the code
below works, one where it doesn't. I am using the listindex command to tell
what name has been selected. However, with the code below, the listindex is
0 when nothing was selected or 0 when the first item on the list is
selected. What could cause that?

If CHUpdate.ListThoseShts.ListIndex = -1 Then
MsgBox "You did not select a worksheet. Please try again."
GoTo 10
End If

Thanks,

Bill