View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomas donino thomas donino is offline
external usenet poster
 
Posts: 89
Default how to trigger a validation change

I have a macro which works properly and changes the drop down list based on
what is a certain cell (H3)
The drop down list is for cell (C5).
The problems I have are;
1. Where does the code belong? a module, on the worksheet? if so under
worksheet or declarations
2. I only want this to run when some one selects cell C5 so that the proper
dropdown box is there

Ty in advance