On Oct 13, 9:17*pm, "Jim Lavery" wrote:
Does anyone know the VB code in excel to produce an error message if the
code breaks down. For example if the user doesn't select from a drop down
list it tells them to "Select from the list"

Hi Jim,

You seem to be talking about two different things here. The example
you use is actually Validation, which is generally used to prevent
errors from happening. Handling an error after it has happened is a
different matter.

Which of the two are you actually seeking help on and can you expand
the context a little. What are trying to do and do you have some
example code you can post?

Br, Nick.