Triggering Event

[moswitch]

I have a private SelectionChange and Change sub routine in my VBA code which works well once initiated, the problem I have is that I am having a hard time triggering these events when clicking on the pull down arrow of a "Data Validation" List. Excel does not seem to recognize clicking a list as an event, how can I trigger an event when I click on a validation list?

 

[N1GHTEYES]

If you have the validated cell selected and you change the value to a new item in the selection list, the SelectionChange event will not be triggered, because you have not changed the selection. However, that process will trigger the Change event.

Is that not what you need? What is the problem exactly?

Tony

 

[SkipVought]

hi,

Do you want to trigger the SelectionChange event or the Change event in the worksheet? BIG difference.

Using the Data > Validation - LIST feature with the in-cell drop down, You must FIRST select the DV cell. That will trigger the SelectionChange event, When you make a NEW selection, that will trigger the Change event.

Clicking the drop down, triggers no event, like a ComboBox.

If no other cell is ever selected, the SelectionChange event will never be able to be fired again. That DV cell remains selected thru many Change events as new values are selected from the drop down.

Exactly what is your problem?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[moswitch]

You both have answered my question, thanks again.