Running Balance : How to Create Running Balance in Excel Userform | Print Statement Like a Passbook
Vložit
- čas přidán 6. 09. 2024
- How to Create Running Balance in Excel Userform | Print Statement Like a Passbook
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. How to display your running balance in Excel Userform's Listbox with opening and closing balance.
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.
Free Download for Practice : drive.google.c...
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
You are a great teacher of v b a Coding
Excellent sir
Thank you for your comments and like
"Your every videos very helpful". Then I am watching every your videos,You are "Magician of Excel VBA"🙏🙏🙏
Thank you very much
Ajay sir, thanks a lot for granting my request. This tutorial and the previous one, both are not only enhancing the technical knowledge but also accelerating the logical thinking. I have been following you for almost a year now. You help a student in developing a logic for each task in creating an application. This is a very rare talent in teachers. You are blessed with this gift.Some teachers are extremely intelligent and smart but when it comes to translate their experience to their students, they fail to communicate effectively. You always shine in showing how to approach the task logically in each video. I am glad, you do not edit your videos. Keeping your mistakes in the videos as they occur, is a helping hand to know the real pitfalls and to know how to come out of these holes. Very thankful to you sir for your hard work. Regards.
I appreciate and thank you for such comment this help to create new thing and motivate us. Thank you again for like and share
Wow very Nice 👍 Great Sir 👌
Thanks
Excellent work done for beginner and advance learners.
Sir Pl explain your password protected video in current sitaution.
Really appreciate your wish to share knowledge and develop skills. Your videos will become more comprehandable and helpful if you break long videos in parts. Because too much switching between screens and entering data again and again tire eyes and losing focus
Great feedback, will now upload in parts thank you for your support and share this video
Wow Sir Amazing you are the Best 💫💫💫💫💫💫🙏🙏
Thank you
vba fun is really fun indeed, thank you
Excellent statement coding ...great sir... and plz do video on stock inventory program..if possible sir...thanks god bless you sir....
Thank you ❤️
Excellent sirji
Statement me balance ke pichhe Dr. CR. Lana hoto kaise lashakte hai
Thank you for your comment, here you can use number formating
How use number formatting plz guide..
Very nice Examples Sir
Thank you
Great coding excellent Sir 👌
Thank you
Amazing Ajay sirji,
Very helpful coding..... great
Thank you for your comments and share ❤️
Sirji,
aapse bat karni he to mobile number mil shakta he ..?
Muje VBA class bhi join karna he....
Please contact on instagram
Sub Advfilt()
Sheet2.Range("L2:R99999").ClearContents
Sheet2.Range("A1:F" & Rows.Count).AdvancedFilter xlFilterCopy, Sheet2.Range("H1:J2"), Sheet2.Range("L1:Q1"), False
End Sub
ye kam nahi krta please help me
Mr. Ajay, as i started viewing your vba fun videos for different programs, i developed interest in this language. Though i am 73 years of age and on the verge of reducing grasping power but still try to fight the odds. Recently I was experimenting on Running Balance on your guidance and trying to achieve the final developed program but unfortunately found difficulty in advance filtering step. it is not considering the between dates value in filtering. Please guide on this. Thanks
Sir first of all thank you very much for watching and learning. I appreciate your comments and it really help us.
I would happy to support in your program.
See advance filter does not work with exact date format so keep date valu in other cell and then link with criteria in criteria field. Or watch again video because I have explained each and every step.
Thank you
Awesome video again sir
Varun
Thank you
Abnormal .. Thank you very much..
I appreciate thank you
ممنون
Hi sir account perfect chal Raha he new account open ho raha he or debit credit entry bhi ho rahi he jub usko transaction deshbord me jake search karte he jitna bhi entry kiya he wo show nahi hoga blanck hi raha he entry pls fix it
Sir, I want to display all accounts closing balance in adding another list box. Is it possible ? How is it. I use this video technique for another purpose. I love your video and new ideas that improve my learning vba. Thank you.
Yes it can be possible please keep watching will upload very soon
Thanks. I am waiting..
Hi sir, pls help me
Todays / Current date entry not show when i search transaction please solve this.... thanks
Sir kishi bhi tarh ka vba application banaye to ushe desktop par kese chalaye aur ushe open kare ke data entry aur save and delete and edit kar sake air excel sheet bina open hoye hi application run kare please yeshe aap batayege
Thanks sir.
How sum more than one account?
Sir transection deposit and withdraw search update aur delete kaisy Karen ..save transection aapki video dhakh kar banali hai lakin search mein ya Sahi kaam Kar rahi smartcodding method Kay code sy..
Sir all account ka summary kaise create hoga, is par ek tutorial dijiega. Thanks in advance,
Yes sure
Thanks
Great keep it up.
Thank you
Dear Sir, Assalamu alykum, At first many thanks for your valuable time & Topic! Could u pls update as of Opening Blc show in 1st row (Beginning of page) & Closing Blc show in Last row (End of Page)? Again thanks.....
Hi thank you for your comments. First of all I have given the opening balance in top and closing balance alao showing in last transaction
Superb A1
Thank you
Amazing sir. Account opening open eala vedio means isse pahle eala vedio ka link bhejiyega sir
Please search running balance on my channel video
Sir, i have download this file but the file is not running with vba?
Exact date not transfer to Cells Through Textbox . Date formate automatically change problem. Please sir solution it. I am a new in this field.
I want to transfer exact date which written in TextBox transfer to same date formate to the cells .
Yes i already tell in one video that date can not exact transfer in sheet. So use dd-mmm-yyyy format to transfer from textbox to sheet
@@vbAFun thanks sir. You always reply our question. Thanks a lot. Great.
Thank you for your support and comment
sir me new account open kar raha hu sub kuch hota he debit entry credit entry jub me tranjection deshboard me jake search kar rahu hu tabhi kuch bhi show nhi ho raha he blanck aa rah he
Todays / Current date entry not show when i search transaction please solve this.... thanks
Sir, Make a video about restaurant management.
Sir jab hum Data entry karte hai to fir search karne ke baad me search nahi hota hai, lekin agar Data entry Excel me jake Date Manual entry kare to search hota hai
I see it took alot of step just to run the userform. After opening the excel file,we have to goto developer,macro,run the macro. Is there anyway to run the macro directly from excel sheet?
Yes write the code in work book open event
I have Querry
Ager hum userform pr time set krna chahyn jasa k (Good Morning , Good Evening ) likha ay to kasy hoga ye
Plz guid ?
Yes kyu nahi ho sakta hai am pm ko check karke aap ise bana sakte hai and also this is great idea will make video on this
@@vbAFun but try kia nhe hoya
which date format works better in forms date or text. I noticed that when the date format is converted to text format, the above programs work well else filter don't work. please comment
Yes you use dd-mmm-yyyy
thanks@@vbAFun
Store inventory software..
Ajay ji I tried the date value alternative too but could not achieve the desired results. on the first go it worked but after that it did not. I have 365, could there be some adjustment problem or i may have changed some default setting in Excel.
See when you download the application then you find that when I running the code for transferring data from userform to sheet . In that place please add .value in line end
Kindly respond how to run यूजरफोर्म on office 2021
You just open excel and open VBA editor and double click on userform then press F8 or just click on play button
Sir module1 ke coding kaa. Nai krta he
Good evening sir , any updates about the 26th ..... To the copy area
Yes,i will correct the video or simply open the code and add in the last of control name .value for the date field
Thanks alot for your time but
The from 26th transaction does not copy to copy area, that it work only 1 to 24th
First of all thank you for your comments, I would suggest please check lastrow value is this showing 24 or your exactly last row data no. If there is missing I will update tomorrow
@@vbAFun noted
Thanks
Waiting for the update thanks alot
@@vbAFun please any update about 26th .... Copy area
Sir can u create voucher form Dr and Cr
Yes it can be thank you for your suggestion
जिस तरह हम last row find करके डाटा add करते है क्या हम लास्ट column find करके fix row में डाटा add कर सकते है ?
Yes I have also show that in advance data entry video
SIR JO AAPNE V1 ME OPENING BALANCE SHEET ME FORMULA LIKHE HAI USKO VBA KE JARIYE EK MODULE KAR SAKTE HAI ? TAKI SHEET ME FORMULA DELETE HO JAVE TO KOI TENSION NA RAHE VARNA ERROR AANE KI SMBHAVNA HAI
Yes ho sakta hai use worksheet function ke jariye kiya ja sakta hai
Pls can type it for so I can update ma file
Thanks very much
Nice sir,
Mujhe Account no ke niche Account Name chahiye to kya kare
Sir, instead of using Sheet 2 several times better to guide us by
With Sheet 2
'Code.....,
End With
Hello sir 5.5+ 1.5 user form me kaise add and subtract please reply me
You just use control name and + sign
Todays / Current date entry not show when i search transaction please solve this
Check the code and add .value after the textbox control
@@vbAFun Transaction show to karta hai lekin next days and Sir main aapko batat chalun ki main Ex-Servicemen (Indian Army)Hun ! Main Ise appne house men hone wale daily ke kharche ki liye dekh raha hun
I will explain in a separate video how to correct this
@@vbAFun sir aapke dwaara upload kiye gaye(Runnin Sum_Video.xlsm) isko download kiya lekin isme bhi current yani today entry not shown in statement
@@vbAFun मैं शीट में जाकर आज की एंट्री डेट पर डबल क्लिक कर देता हूँ और इसके बाद स्टेटमेंट चेक करता हूँ तो डबल क्लिक किया गया ट्रांसक्शन तो दिखाई देता है लेकिन इसी डेट में किया गया दूसरा ट्रांसक्शन तब तक नहीं दिखाई देता जब तक उसपर डबल क्लिक नहीं कर देते
👌
Sir Jo ammount apne alag alg cell me entry ki hain main chata hu ki o ekhi cell me add ho.. Suppose man lije ki 1st cell me first balance 100 Tha aur main chata hu ki usme aur add koru like pahele 1000 Tha fir 1000+1000=2000 ho jay jis cell ko updet Kiya tha usi me.. Please iske upr ek vdo baniye 🙏🙏🙏🙏help chatahu
Hi thank you but fir plan karke coding karni hogi. So keep watching and try to understand method
@@vbAFun ok
Thanks very much
Can you just update practice file with the code
Thanks for that
Please watch the video atleast one then check description you will get the link
Sir possible nahi he today wala data update ho
KYA AAP AISE SOFTWARE BANAKE DE SAKTE HO? PRICE?
Ye software free hai agar apko customise karbane hai to please insta pe contact kijiye
sir ji me thoda new hu is liye puch raha hu mene apka ye file download kiya he but form open nahi ho raha he direct excel file open ho rahi he pls kya karu koi help karoge is ke liye
Koi bat nahi aap naye hai to Sikh sakte hai aap alt ke sath f11 press kiiiye fir form pe double click karke run pe click kar dijiye ya F8 press kiiiye
@@vbAFun sir apka hi ek vide me dikhaya gaya he humne sikh liya kese open karne ka thanks
sir kafi samay se ek request thi meri apse food resturant managment sysem k uper video but start me login form jarar dalo or excel sheet hide honi chahiye order le usse samay table wise pls try q ki apke jesa koi nahi sikhata he
Sir, please update in this address option
Sir isme edit option k code kaise kare
Aap transaction edit nahi kar sakte apko reverse entry Lena hoga jaise journal entry karte hai
Sub Advfilt()
Sheet2.Range("L2:R99999").ClearContents
Sheet2.Range("A1:F" & Rows.Count).AdvancedFilter xlFilterCopy, Sheet2.Range("H1:J2"), Sheet2.Range("L1:Q1"), False
End Sub
sir ye code kam nahi krta please help me
same me new accoubnt open kar raha hu sub kuch hota he debit entry credit entry jub me statment me jake search kar rahu hu tabhi kuch bhi show nhi ho raha he blanck aa rah he
Unfortunately.. not in English
So sorry my English is not good
Which part of the code pls
Aap dekho ki kon sa control no hai date ka for code me likha hoga me.txt and no hoga o dalne ke bad .value kar dena hai
@@vbAFun please I only speak English
Thanks sir
Sorry, I hope i am not disturbing you too much
Or koi he jo help kar sakta he qki vba sir to help nahi karege unhone lagta he Kasam kha liya he iska solusion nahi Dene ka kisi ko bhi is liye rply bhi nahi kar rahe he or koi he jo solusion la sakta he latest data update karne par show nahi kar raha he
Aap iske code me jao aur aap dekho jaha pe hamlog data transfer kar rahe hai userform to sheet me oha pe me(control name).value kar de
@@vbAFun nahi samje bhai aap batado nahi samaj me aa raha he
@@vbAFun Private Sub SearchBtn_Click()
If Me.AcNo = "" Or Me.StrDate = "" Or Me.EndDate = "" Then
MsgBox ("Please Ensure to fill Account, Start Date and End Date")
Exit Sub
End If
Sheet2.Range("H2") = Me.AcNo.Value
Sheet2.Range("I2") = ">=" & Format(Me.StrDate, "#")
Sheet2.Range("J2") = "
Private Sub StMt_Click()
With Sheet3
.Range("B2:B4, G5").ClearContents
.Range("A7:G99999").ClearContents
LastRow = Sheet2.Range("L" & Rows.Count).End(xlUp).Row
Sheet2.Range("L2:R" & LastRow).Copy .Range("A7")
.Range("B2") = Me.AcNo.Value
.Range("B3") = Me.StrDate
.Range("B4") = Me.EndDate
.Range("G5") = Me.OpBal.Value
Sheet3.PrintOut
End With
End Sub
YA IS WALE CODE ME KYA DALNA HE BATA DO
@@kamleshkc535 maine ispe Q & N ka video bana rakha hai usko dekhiye maine usme bata hai
Is this ok or some correction is needed
Private Sub SearchBtn_Click()
If Me.AcNo = "" Or Me.StrDate = "" Or Me.EndDate = "" Then
MsgBox ("Please Ensure to fill Account No,Start Date and End Date")
Exit Sub
End If
Sheet2.Range("H2") = Me.AcNo.Value
' Sheet2.Range("I2") = ">=" & Me.StrDate
' Sheet2.Range("J2") = "=" & Format(Me.StrDate, "#")
Sheet2.Range("J2") = "
Oh means you got an error using searching . As per code this is fine. Please run one by one pressing f8 and check where you got the error
@@vbAFun right Ajayji thanks I'll try
Sir Mujhe Ek Excel Formula chahiye
Bahut try kiya samajpe nahi a araha hai
Please help me
How i can contact you.
Kis Kam ke liye formula chahiye ?
Sir I'm working in hospital
Mujhe Daily Bed Occupancy ka count nikalna hai
Uske liye chahiye
Aap mujhe Apka email id share kiya tho File bhej doonga with details
Sir I'm Expecting Reply from you..!
Please contact me on instagram
Dear sir
Your so kind and I really appreciate your help on my project file.
Thank you so much for your immediate response.