detect when a data validation drop down has been changed

[cogswel__cogs]

How do i detect when a data valiadation drop down selected and changed has been changed.

Do I use activecell or target?

 

[Fluff]

Something like

Private Sub Worksheet_Change(ByVal Target As Range)
   If Intersect(Target, Cells.SpecialCells(xlCellTypeAllValidation)) Is Nothing Then Exit Sub
   MsgBox Target.Value & vbLf & Target.Address
End Sub

 

[cogswel__cogs]

Thank you so much.

 

[Fluff]

You're welcome

 

[cogswel__cogs]

Little off topic.
I am using this for a summary pages of departmental tabs.
I am using Indirect to pull of the tabs and then allowing user to dropdown and pull certain info. All the tabs are the same so user can sellect "Gross sales" and it will pull all the sales. Want to know when the column is changed because depending on that they request macro will change formating for that column to (%,$,#) .
I have to do this with VBA, I can't change number formatting with conditional formatting can I?

 

[Fluff]

I can't change number formatting with conditional formatting can I?

Yes you can. In Cf click Format & then Number & choose what you want.

 

[cogswel__cogs]

Ok Thanks again.

 

[Fluff]

You're welcome

 

[MUKESHY12390]

Ignore, got wrong window.