How to create a Cheque drop Box in Excel VBA || Cheque management Application in Excel

#nsutradhar
Today we will learn How to create an Cheque Drop Box in Excel. In this tutorial I will discuss step by step.
First of all You need to design a clear plan in your mind when you want to build such application.
1. Create or Design a Userform by using toolbox in excel visual basic.
2. To create this I used three listbox and comboboxes and TextBoxes.
3. After design this You need to create a data entry form by which you can input your cheques which you received from your customer or clients. You can input multiple cheque through this data entry form. When you click on add button, the data will add on ListBox1. After completed your all cheque, when you click on Save button It will transfer your all data from ListBox1 to worksheet ( Here Worksheet Name is "ChequeDropBox").
4. create vba codes for ListBox2 And ListBox3 where you can see both cheque which are in your hand ( those cheque which are not deposited in Bank ) and which are send to Bank for clearing.
5. After receiving Bank response you need to change the status of that cheque clear or return.
6.If you need to to view all clear cheque or all return cheque, so there are two extra commandbutton.
7. View all cheques which are to be send to bank as per date by using TextBox and spinbutton.
If You want to see the vba codes then goto my blogspot
https://nsutradhar.blogspot.com and you will download link also
or
https://nsutradhar.blogspot.com/p/how...
Please write your valuable remarks. So that I can inspire to create new one.
And Subscribe my channel first because your one support can highly inspire to me.
Thanks for wathiching this video. To view more video tutorials please got to my channel page
my facebook page link
https://www.facebook.com/103961264467...