I would like to have the user be required to make a selection from a list box. Can you help me with the following? It works for a TextBox.
Thanks much for your help!
'check for ListBox1
If Trim(Me.ListBox1 .Value) = "" Then
Me.ListBox1 .SetFocus
MsgBox "Please make a selection form the list."
Exit Sub
End If
Thanks much for your help!
'check for ListBox1
If Trim(Me.ListBox1 .Value) = "" Then
Me.ListBox1 .SetFocus
MsgBox "Please make a selection form the list."
Exit Sub
End If