View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
step_andy step_andy is offline
external usenet poster
 
Posts: 5
Default data validation lists

Thanks. This solved my issue.

"Dave Peterson" wrote:



But if you're using xl2k or higher (won't work in xl97), you could use the same
table and a worksheet_event that overwrites the value in the cell with the short
name.