Change validation will run macro?

[pruleone]

Hy,

is it possible to force macro run when I use validation in excel sheet?

 

[SkipVought]

Hi,

There is no event associated with Data Validation.

What are you attempting to do?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pruleone]

I need to update data only one place and there isn't any other menus, to change or where to write any thing so I thought maybe there is a possibility to run macro only when I choose somekind of possibility from data validation.

But is there possibility to force macro run when I choose some surtein worksheet?

If there isn't any possibilities I can always make some kind of button. But if it is possible to make macro run automaticly then it would be better solution for me.

 

[PHV]

force macro run when I choose some surtein worksheet
You may consider the Workbook_SheetActivate event procedure in the ThisWorkbook module.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

If you actually make a CHANGE to a value, via Data Validation or any other method, the WorkSheet_Change event fires, but it had NOTHING to do with Data > Validation..

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pruleone]

Thank you all,

as my workbook has one button to update data from internet then I put link update command also under that button.