Data validation in a list box

[Padawan018]

I have a user form with a list box and I want to make sure that the user selects an item within the list box. The code I have is:

if Listbox1.value = "" then
msgbox("Please select one of the entries.")
end if

any help would be appreciated.

Thanks.

 

[Norie]

What's the actual question?

Try this.

If Listbox1.ListIndex = -1 then
  Msgbox("Please select one of the entries.")
End If

 

[Padawan018]

Thanks Norie Unfortunately the error check not picking up.

I want to know how can I error check a listbox to make sure that a selection is made.

 

[Norie]

I'm sorry but you haven't really asked a question or explained what the problem is.

Where did you try your (or my) code?

 

[Padawan018]

I am writing the code in VBA for a user form. I have a command button and when the button is clicked it checks all the entry boxes(text, combo, and list). All of the error checks work except the one for the list box. Is there code to error check a list box to make sure a selection is made in the list box.

 

[Norie]

The code I posted should work, and the code you posted might also work.

Without seeing the rest of your code it's hard to tell where your problem lies.

Is the code actually being triggered when you click the command button?