How about Data Validation
Select the cell that is used for the thickness input
Go to Data Validation
On the Settings tab under "Allow" choose decimal
Set your Maximum and Minimum values which would cover acceptable
entries
Then click the Input Message tab and type a message which will show up
when the user selects that cell - something like "Thickness Required -
Type numeric characters only"
Then on the Warning tab type in another message which will show up if
your user fails to follow the first message - something like "Invalid
Entry - Do not type non-numeric characters"
Then click OK


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=539976