Textbox data validation problem

[Philb1]

Hello Everyone.. I've got a dropdown list with three options. The macro itself works fine. The problem is data validation. The options are "Left" "Right" "Centre" The problem is if you accidentally hit a key while tabbing through & enter something else in the dropdown, it throws a spanner in the works. What I'm after is a way of checking to see if one of the options is in the dropdown list, if not or something else is, goto an error handler & blank the dropdown. The reason I'm using GoTo is I can't fathom on error resume next. It seems to not fix the problem, just tell me there's a problem, advance through the macro with rubbish as the outcome. I've got the error handlers sorted. I need something like my suggestion below, but preferably I want it to work I have other error handlers that are doing exactly what I need, but this one's stumped me

Please Login or Register  to view this content.

I've tried all combinations & tried different solutions & found nothing that works
Thanks

[Philb1]

I've extracted the part that's giving me grief. Hopefully it's more helpful than my last post

Please Login or Register  to view this content.

Thanks

[Philb1]

I sussed it & thought I'd show everyone how easy it was & that's the reason I couldn't see it
[/CODE]
If Directions.Value = "Left" Then
Directions.Value = "L"
Else
If Directions.Value = "Right" Then
Directions.Value = "R"
Else
If Directions.Value = "Centre" Then
Directions.Value = "C"
Else
Goto handler2
End If
End If
End If
Call EnterData ' Goes to the data entry private sub[/CODE]

Now why didn't I see that yesterday

I see that you can't change the colours of the code text si I had to edit