Make listbox selection a requirement

[Homegrownandy]

Ive tried a few ways/looked at a lot of examples. I cant get this working. If the user has not selected a line in the listbox i want a message to come up and the code to exit.



This is my poor attempt:

If Me.lstFileList = Null Then
MsgBox "pick a template."
Exit Sub

Else: End If

Ive tried using .value -1 and multiple other sugestions but it seems to totally skip past this and error on the later code.

[isladogs]

There are at least three errors in that code.
The following should be ok

If Nz(Me.lstFileList,"") = "" Then
     MsgBox "pick a template."
     Exit Sub
End If

[Homegrownandy]

brilliant, works perfect.

[isladogs]

You're welcome