Thread: Islike function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamie[_6_] Jamie[_6_] is offline
external usenet poster
 
Posts: 7
Default Islike function

Hi All,

I want to put the following format as a requirement for
data entry via a userform:

123/4567-K

three numbers, a slash, four numbers, a dash follwed by a
letter.

I have tried ###/####-[A-Z]. It seems that I can not get
the slash and the dash. I am not sure of their format in
VB. Any help is appreciated. Thank you in advance.