Thread: data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice choice is offline
external usenet poster
 
Posts: 18
Default data validation

i have a list of phone numbers (C1:C100), in A1 you enter in a phone number, if the number you enter is from the list, nothing happens, if it is not on the list, i need a text box to pop up saying "Continue" then yes or no. if yes, i need Macro1, if no, nothing to happen

Thanks in advance