Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sisilla Sisilla is offline
external usenet poster
 
Posts: 12
Default Data Validation

I would like to prevent users of a spreadsheet from
entering data into certain fields when they have made
certain selections from a drop-down list. I have been
looking at Visual Basic Help topics, and there are
examples of data validation methods; however, when I copy
the code (and modify it to my spreadsheet's needs), I am
receiving compile errors "Named arguments not found." I am
new to both Excel and Visual Basic; please help me.