View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
egun egun is offline
external usenet poster
 
Posts: 88
Default Data Validation Drop Down Using VBA?

Is there a way to programmatically cause a drop-down list in a cell with
validation to show? On one of my worksheets, if the user enters a certain
value in one cell, another cell is populated with a list of titles the user
must choose from. I would like that list to automatically show ("drop down")
to remind the user to select something.

Thanks,

Eric