Thread: Validation List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default Validation List

Hello all,

In Cell C5 of my Excel worksheet, I have a Validation List. There are
values in the Validation List, and when the users select a value from the
Validation List, I want my code to perform a list of procedures.

How should I write a code to triggle my code to run when the users select a
value from the Validation List or change a value from previously selected?

From Help, I saw the following event:

Private Sub object_DropButtonClick( )

I don't know the above event would work. What should I have in place of
object in event? ValidateList?

Thanks.