View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] aidan.heritage@virgin.net[_2_] is offline
external usenet poster
 
Posts: 17
Default How do I assign point values on survey answers?

Use the Change event of the worksheet and use if statements to handle
it

if lcase(target.value)="yes" then target.value=1
etc