Thread: Predictive Text based on cell range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
  
Posts: 417
Default Predictive Text based on cell range?
Why not simply use Data Validation for cell A1, and have it obtain its list
from range $E$1:$E$50? See the Validation command in the Data menu (Excel
2000).

--
Regards,
Bill Renaud



Reply With QuoteReply With Quote