View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dillonstar[_3_] Dillonstar[_3_] is offline
external usenet poster
 
Posts: 1
Default restrict entry in a textbox to a range of values

I have a textbox that I want to restrict to a range of digits
(9200000000 - 9299999999).

I have tried various ways to bring up a message box when an incorrect
number has been entered, but everything I try seems to bring up the
error message AS you type, rather than when the complete number is
input.

I have managed to restrict to numerics and by field length sofar.

Can anyone help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/