View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drofnats drofnats is offline
external usenet poster
 
Posts: 2
Default preventing input of illegal characters in an inputbox

Still a little new at vba. Can someone tell me how to
prevent someone from entering in spaces or any illegal
characters (like & % @ etc) into an InputBox? At least
without writing a whole lot of "ElseIf" statements?

I have my script so it so names the range as whatever they
type. That's why I need to restrict entries. Thanks.