Mannual Input in dropdowns

  • Thread starter Thread starter David Ralph
  • Start date Start date
D

David Ralph

How do I go about stopping people trying to type an entry into a populated
dropdown on a worksheet?.

Currently if someone types an entry the code crashes as the dropdown is
bound to the second column
so the data passed to the procedure is a NULL value. I've tried checking
the value is NULL using-
if ... IS NULL as well as if ... = NULL and using the On Error handler but
none of these have worked.

Any Suggestions?

Cheers

Dave
 
Back
Top