> *Thanks a lot* Debra, it works perfectly! :-)
>
> If I had 2 or more that one data validation cells in the same Sheet1, what
> should I write in the VBA code in order to refreshing both cells? I tried
> to adjust the vba row as follow:
>
> If Target.Column = 2 and 9 Then
>
> but only the first column refreshs.
> Anyway thank you very much for your first answer and best wishes!
> Marc

Delete my last post Debra, I solved the problem by myself. In the vba row we
must use "Or" and NOT "And", so both data validation can refreshing.
e.g.
If Target.Column = 2 Or 9 Then

Kind regards,
Marc