I write the code to find the sick leave balance for all staff. My script is running well, but I don't like
The fact that my coding in the Debit Sheet is not good enough as a block of code [that I comment it out for you to see] is repeated for each elseif statement.
I wonder if you can show me how to rewrite it as small sub and calling it in when need it.
That will be wonderful to me.
And here is the link to my file
https://drive.google.com/file/d/0B0rMYzlRxO33TXFnMXBpb1lUUGc/view?usp=sharing
Thanks heap
The fact that my coding in the Debit Sheet is not good enough as a block of code [that I comment it out for you to see] is repeated for each elseif statement.
I wonder if you can show me how to rewrite it as small sub and calling it in when need it.
That will be wonderful to me.
And here is the link to my file
https://drive.google.com/file/d/0B0rMYzlRxO33TXFnMXBpb1lUUGc/view?usp=sharing
Thanks heap