$range -> Validation -> Add( { 
  Type => xlValidateList, 
  AlertStyle => xlValidAlertStop, 
  Operator => xlBetween, 
  Formula1 => "open; high; close" 
} );