Tank level control in VBA excel

I am trying to simulate the tank level control in VBA excel If I increase the flow level will increase to certain value.how I can write the codes in VBA excel to do simulation?please I need help