View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul W Smith[_3_] Paul W Smith[_3_] is offline
external usenet poster
 
Posts: 11
Default Text Box - Restricting Entry

I want to restrict the entries that are allowed in a text box to just the
numbers 1 to 11.

I have fiddled around with the KeyDown, KeyUp, and KeyPress events, only
allowing entries with ASCII codes between 48 and 56.

However I cannot get it right. Can any expert VB programmers please supply
the necessary code.

Paul Smith