VBA or Excel formula for random 10 digits numbers generator

My goal is to generate 10-digit random numbers and divisible by 9. Can be solved this via excel formula or VBA ?