Delete rows from Listbox

I have a UserForm with a ListBox. I also have a Command Button to delete rows from the ListBox. (Code Below), due to the way I've constructed the ListBox it MUST contain at least one row. I'd like to include code in the DELETE command that return a Message stopping the delete if there is only one row in the Listbox .. any suggestions.

Please Login or Register  to view this content.

Difficult to say for sure without sight of a sample file for context, but perhaps this?

Please Login or Register  to view this content.

BSB

BadlySpelledBuoy... Many thanks that worked fine

Glad I could help

BSB