View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen Jen is offline
external usenet poster
 
Posts: 119
Default Recording a macro to change item selected in drop down list

I am trying to record a macro in Excel that will reset values that are
standard for specific customer programs we have. The worksheet has different
data validation drop down lists and the correct selection is different for
different programs. Selecting the correct value while recording the macro
doesn't seem to work. Is there a special trick to make this happen? Is this
even possible? Thanks!