Tank level control in VBA excel

PLC (Programmable Logic Controllers)
1

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