Jacqui,

Why not just use the Listbox click event if it's a userform or control
toolbox listbox, or simply assign a macro if it's a forms listbox on a
worksheet.

--

HTH

Bob Phillips

"jacqui" wrote in message
...

Can anyone help? What is the correct syntax to determine
whether the user has made a selection from a listbox?

I tried LstMinus.Selected = False
VBA didn't like that

I've also tried
LstMinus.Value = "" and
LstMinus.Value = Null

but it's still not right. Can anyone advise please.
Many thanks Jacqui VBA is below

If LstMinus.Value = Null Then
Range("C13").Select
ActiveCell.Value = ("01" & " " & sMonth & " " & 2003)
dDate = CDate(ActiveCell.Value)

iMth = DateAdd("d", 45, dDate)

GoTo Continue:

End If