Multiple Data Validation Checks

Thanks Steffen.
I thought of doing that and it will work but isn't it "after the fact"? The user has already made a change. How do I put the changed value back to it's original (previous) value after the pop up message?

Is there a way to check before the value is changed? If not, I can use your solution but still nedd to know how to restore the previous value.

Private Sub worksheet_selectionChange(byval target as range)
   if target.column = 6 ' change to fit
        ' here you create the check if the user has rights
        if not you_user_id_var = "Finance" then
               msgbox("You do not have rights to change this column")
               range("A1").select

'NEED TO RESTORE THE PREVIOUS VALUE HERE

       end if
   end if
end sub

Jim