Running Balance :How to Create Debit & Credit Transaction form in a Single Excel Userform
HTML-код
- Опубликовано: 15 сен 2024
- How to Create Debit & Credit Transaction Userform in a Single Excel Userform | Data Entry Software
I have created this excel application to maintain your daily receipt and payment of individual account on daily basis with transaction wise running balance statement.
From this video you will learn how to create a Uniuqe UI Design in Excel Userform. Not only design in this video you will learn how to learn a unique method to develop your logic to create excel application to earn money as freelancer.
course registration form : forms.gle/dPKe...
Smart Coding Method Video : • Data Entry Software in...
Join this channel to get access to perks:
===============================
/ @vbafun
===============================
About Excel vba
=================================
Excel VBA is a very useful programming language where you can do your work very smartly and this language is very simple to use. From this channel, you will learn how to simplify your code in excel VBA to automate your sheet for daily routine work as well as will teach you how to create an application in excel VBA to make the data entry, invoice, keeping a record of data inventory and many more excel application which uses in each and every offices and school.
=================================
Our Aim to Develop Skill in Excel :
=============================
userform in excel in hindi
excel vba training
excel application development
simple method to writing code
excel micros
userform automation
excel sheet automation
Free sample excel application
=============================
Never Seen Before Playlist in Excel Vba :
==================================
• Never Seen Before Tricks
==================================
Other excel vba training Video :
==================================
School Manager - Student Admission, Student Receipt, School Software
• School Manager Pt 1 | ...
Small Business Applications - sale/purchase/inventory
• Small Business Applica...
Employee Manager
• Employee Manager
School manager in excel
• School Manager
DatePicker in excel
• DatePicker
Advance Data Entry Software in excel
• Advance Data Entry App...
PoS in Excel with Image Control
• PoS with Image Control
PoS in Excel
• PoS ( Point of Sale) i...
===================================
Our Social Media Contact :
===================================
Facebook : www.facebook.c...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
====================================
Disclaimer :
=====================================
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research, Fair use is a permitted by copyright statute that might otherwise be infringing, Non-profit, educational or personal use tips the balance in favor of fair use
=====================================
#ExcelApplication #excelvba #dataentry #passbook #MsExcel
Dear sir,
Good evening,
first of all required below things:
1. login, user role(admin for assign the new role or upgradation or deactivation)
2. capure all like user wise log / account wise or between dates / events through audit trail. if check Audit trail through pdf file availability only.
3. never showing on excel sheet of Audit trail report. Because to avoid the manipulation.
4. if any mistake in amount withdrawal or deposit approval required to higher role person.
5. only current form / required form enable. remaining all forms are disabled required.
6. Never access in excel sheets even admin also.
Sirji aap ke video se bahut logic develop hota hai thanks
Thank you for your comments and share ❤️
My Dear Vbafun sir
Very good explanation
Thank you
AVG Raju
I appreciate thank you for your comments and share
Ajay ji! as always this tutorial is very educative. Thanks for your hard work. Pleaes keep it up.
Thank you ❤️
Wow sir Amazing your all video are fantastic and lovely
Thank you for your like and share ❤️
Excellent and valuable video sir, thanks for uploading continue.
Thank you ❤️
Very good tutorial. need something extra. hats off sir.
Thank you keep watching to learn extra 😊
A couple of requests please, in the context of this tutorial: 1. Can you add another column having a running total for each of the rows. 2. A similar use of this tutorial, for Bank Statements' reconciliation in VBA. Majority of the times, each bank gives you a csv download for the transactions to be roconciled with your local books. It would be nice to learn how to develop an app in VBA for this reconciliation.
Regards.
Yes sure and thank you for your support and comment
App ki Tamam videos la jawab Hain
Thank you for your comments and share this video
Entry should reverse by transaction no and by authorisation of other user . Transaction no should generate automatically and random not sequencely
Excellent Ajay ji
Thank you ❤️
Awesome video sir like you...
Varun
Thank you
Good job Sir. please translate to English language for some of us that cannot understand Hindi
Hi first of all thank you for your liking and sharing. But sorry i am not good in explaining in English .
But i uploaded caption in auto translated English language
Hello . I have a data table with 10 columns in Excel and I want to display two separate ranges of this table in a listbox form. For example, the first five columns and the last two columns. Thank you for your guidance.
nice video..... Sir
Sir party k ladger debit credit ek software banao........ Please
Aap is video se bhi debit credit ka application bana sakte hai
Wow great video
Thank you ❤️
Excellent sirji
Thank you for your comments, please share this with your friends
Sir give you WhatsApp number
Wow So Nice and very Good
Thank you ❤️
Excellent Sir make a loan ledger also sir
Assalamu alykum, Dear Sir, very nice debit &credit but need another column for showing Balance...as well as sub total in Sheet2
Again so thanks....
I have given for see the balance in real time. Whereas, wait for next video for complete details
@@vbAFun Thanks for your valuable time.
Amazing
Thank you ❤️💕 please share this video to support us
Sir ji helping your code make a simple number pad make,i want to use this like a calander how can use it
Waiting for your reply
Great One please help me with excel file.🙏🙏 Please.
Excellent Sir please is co or advance kejea.
Hi thank you for your comments, please customise it as per your requirement, we will share the file in next video
Sir, AAP Expence Manager pe ek detail video banaiye, with account statement and pdf
Hallo, the advanced filter is not working
Great Video places help me with the excel file. 🙏
Sir Running balance KO second video jus mein search aur update kaisy Karen 2nd video bhi banaen aur aik aur video jus mein transfer amount aik party ka debit aur 2sry ka credit with one textbox save update kaisy Karen..sir plz
Amazing. Sir iske pahla wala part ka link bhejiye sir. Mai dekhna chahta hoon
ruclips.net/video/PbHANP-wGS4/видео.html
@@vbAFunsir thank you reply ke liye pahle . Mai yeah puchhna chahta tha ki isse pahle ka bhi koi part hai kya sir ya yeahi pahle wala part hai
@RAJUKUMAR-zd8xf iske total 2 hi part hai
@@vbAFun sir mai new hoon VBA code me. Mujhe ek worksheet me running total karna hai sab kuchh sahi hai par running total jo column f hai automatic results nahi de raha hai jab Tak ki mai use select karke random number dalkar enter press na kar dun tab tak. Kya problem ho sakta hai . Yadi aapka mail I'd ho toh pls share with me sir mai woh workbook bhejna chahunga. Thank you sir
@RAJUKUMAR-zd8xf apne agar formula use Kiya hai to fir . File menu pe click karke option ko select kare then click on formula tab then aap usme pahle me hi automatic ko select kar de
Sir thanks for making this video.... Sir is it possible if we enter same account number and it prompts that account already exist?
Yes, you have to modify some code in module to restrict same entry. Whereas in this video if you enter same account that will be updated in your existing account detail
Sir is program me multiple account number ka detail ek he time me opening and closing detail dekh sakhte he kya sir
sir multiple sheet ke liye bana dijiye with combobox text selection
Educative video how can I get the template picture to be used for the dashboard
hi sir pls make one more video for sms when I debit and credit that time sms should come on the mobile number.
For that you need to buy sma subscription
best
Thanks
Transition history ka bhi option de degea
Respected sir,
jis project ki coding zyada ho jaey,,
kindly oska link mention kr dia krain,,,,
Mai samjh sakta hun isliye maine ab Chhota chhota video dal Raha hun jisse ki aap asani se bana sake
Uske alaba mai e latest series ka file part three me upload kar diya hai
Sir can u plz make video where we have (date )( product) (amount) column .. the data should save in lastrow but payment we received that will deduct from first row ..and uper row should be deleted when the first row amount received or when the value of that row amount column become zero.
Idea is good will make video soon keep patience and keep watching
Ok thanks ill must wait for this video
Banking exel software banwana tha ji
Ajay sir, I have been using save/Search/Delete control developed by you but this time I am stuck because my userform has one combobox alongwith 6 texboxes and combobox comes at 4 position so i dont know what to do. When i save the form combobox value does not save in excel sheet.
Please not that if you are using loop or module for save and delete ensure that all the control name in serial no
@@vbAFun sir just to make you understand, imagine in transaction form purpose has combobox. I have a list of purpose to choose one
Yes also combobox name should be same as textbook but serial no. And if if you again issue please watch any data entry application video
@@vbAFun you mean to say combobox ka naam textbox rakhdo ? Same sequence main ?
Yes
How we will make statment with opening balance and running balance
Thank you for your comment, Wait till next video, we will complete this project as per your requirement.
Sir can you make ti like this running software
Already uploaded
Sir ji sara module bana liya he lekin sirf data entry kaam kar raha he lekin search or Delete error de rahe hen, ?
Jab tak transaction men jakar date per double click nahi karte tab tak transaction search men show nahi karta hai iske samadhan per bhi Video banane kak kast karen Thank
Sir ji ye sheet download kese hogi link dijiye
Sir ji ise me reconcilation bana sakte he kya
Yes bana sakte hai, but isme thoda sa change karna hoga kyuki isme keval deposit and withdraw ka option maine diya hai
Ajay sir aap practice workbook kab upload karoge ?
Next video me ek sath final karke
hello sir iska koi
practice file do
Yes check part two. Ideo description
Entry can be reverse today as well as previous day
As i said in video, If you want to revers or transaction in previous day you can use, Datepicker
Sir very nice, ek question sir ki, ek userform1 pe open dusra userform2 ke upar printpreview open nahi ho raha hai, printpieview excel sheet par hi open hota hai kyo sir.
Yes, aur jab print preview karte honge to userform kam nahi karta hoga right
@@vbAFun yes sir, kese karu, kya dono userform ko hide kar du yaa dusra method hai, plz bataye sir
Mai uspe alag se video banaunga uske liye kon sa method use hoga
@@vbAFun apne kisi vba userform me print preview show ho jaaye to mazaa aa jayega, sir
O ho sakta hai usme koi problem nahi hai
sir,, iis video ka dusra part kob ayega...
Already upload hai please visit channel
Sir, Excellent video. Sir aap ki website kaam nahi kar rahi
Yes due to technical problem website is not working sorry for that
Sir when upload next video
Sorry I was some urgent house work so that I have not uploaded today will upload tomorrow
How to create School results sheets ?
First thing nk what should you require then create data ase and do the accordingly
@@vbAFun make the video plz.
How to I get this
If you want this application contact me on instagram as this is paid service but if you want free then please watch the video and follow the instructions for creating
Ms Excel Bank account type software make you sir and sir link given it (ms excel#happytohelpyou )
Please sir making you are very very thank you sir
Sir ac no dalty hi us name aur pic BHI ana chahiya plzzz help me
Plezzz tell me VBA code for ac name and pic plzzz
Aap last video dekhiye aur usi method ko use kar ke photo dal sakte hai
@@vbAFun thanks Sir 😊
Sir transaction Waly userform mian jis tarha balance label caption main show host hai iss tarha label caption main ac taitel BHI ana chahiya Plzzz iss Ka code bata dain
Textbox ki jagah lable ka use kare aur caption me value ko dale
please advance level make
Advance userform ka course kitne mai purchase kar sakte hain
Abhi uska koi live class nahi chal raha hai, tab tak ke liye suggest karunga ki aap video dekh ke practice kare aur agar koi doubt ho to aap channel ka membership leke support le sakte hai
@@vbAFun ok sir
@@vbAFun videos toh continuously dekh raha hun apke
sir es main manully date dal skty ha
Haan dal dal sakte hai bas codee Jake control ko enable kar dijiye
Plz send this file
Mujhe ye software chaiye
You can create by watching this video, but if you want readymade please contact me on instagram
Is your website working ??
No, there is some problem so my website is down
@@vbAFun ohh shit
Sir Muje aap se ek Banking software banaaiye mein link Bhejta hun link = > ms excel #happytohelpyou
Great One please help me with excel file.🙏🙏 Please.