chriscousins
New Member
- Joined
- Dec 2, 2005
- Messages
- 43
Hi guys.
Great Board...used it regularly for help.
This is my first question...
I need to restrict entry to a cell to any numeric value plue allow "r" "s" "h" and "a" as well (as well as the upper case of the letters)
I want to delete any entry other than those allowed, and have nearly managed it using target.value and case to select the allowed letters, but how do I allow the numbers as well as the 4 letters.
Hope you understand what I'm trying to acheive.
Help appreciated.![Big grin :biggrin: :biggrin:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Great Board...used it regularly for help.
This is my first question...
I need to restrict entry to a cell to any numeric value plue allow "r" "s" "h" and "a" as well (as well as the upper case of the letters)
I want to delete any entry other than those allowed, and have nearly managed it using target.value and case to select the allowed letters, but how do I allow the numbers as well as the 4 letters.
Hope you understand what I'm trying to acheive.
Help appreciated.