Running Balance : How to Create Running Balance in Excel Userform | Print Statement Like a Passbook

[@annabathulavekatagovindara8883]

You are a great teacher of v b a Coding Excellent sir

[@vbAFun]

Thank you for your comments and like

[@computergyan8334]

"Your every videos very helpful". Then I am watching every your videos,You are "Magician of Excel VBA"🙏🙏🙏

[@vbAFun]

Thank you very much

[@Kuldeep100]

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.

[@vbAFun]

I appreciate and thank you for such comment this help to create new thing and motivate us. Thank you again for like and share

[@kamleshkc535]

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

[@nitinkumarthakare2838]

Wow very Nice 👍 Great Sir 👌

[@vbAFun]

Thanks

[@eyeofthetiger8287]

Great tutorial very nice teaching. I have only one problem , when I type in the AcNo box a certain acount Number, like 1212 and search, then all account Numbers 1212, 1313, 1414 are showing up in the List box with Transactions, instead only the one I have choosed 1212 ? I dont know what Im doing wrong, can you give a short explanation. Thank you

[@navadgiarun]

Very nice Examples Sir

[@vbAFun]

Thank you

[@rajnishgraphicsstudio2756]

Wow Sir Amazing you are the Best 💫💫💫💫💫💫🙏🙏

[@vbAFun]

Thank you

[@bhadreshprajapati7231]

Amazing Ajay sirji, Very helpful coding..... great

[@vbAFun]

Thank you for your comments and share ❤️

[@bhadreshprajapati7231]

Sirji, aapse bat karni he to mobile number mil shakta he ..?

[@bhadreshprajapati7231]

Muje VBA class bhi join karna he....

[@vbAFun]

Please contact on instagram

[@waqasahmad-pt8ze]

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

[@excelshambhu]

Excellent sirji Statement me balance ke pichhe Dr. CR. Lana hoto kaise lashakte hai

[@vbAFun]

Thank you for your comment, here you can use number formating

[@muhammadhanifsoomro3166]

How use number formatting plz guide..

[@shahidarain9679]

Great coding excellent Sir 👌

[@vbAFun]

Thank you

[@diya2909]

Awesome video again sir Varun

[@vbAFun]

Thank you

[@nikichinnu]

Excellent statement coding ...great sir... and plz do video on stock inventory program..if possible sir...thanks god bless you sir....

[@vbAFun]

Thank you ❤️

[@muhammadhanifsoomro3166]

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..

[@ravindrapatel4591]

Excellent work done for beginner and advance learners. Sir Pl explain your password protected video in current sitaution.

[@aqeelahmad1764]

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 ?

[@vbAFun]

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

[@aqeelahmad1764]

@@vbAFun but try kia nhe hoya

[@hasmukhnirmal1263]

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

[@vbAFun]

Yes ho sakta hai use worksheet function ke jariye kiya ja sakta hai

[@Babynyayokli]

vba fun is really fun indeed, thank you

[@Lucky-jm5if]

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?

[@vbAFun]

Yes write the code in work book open event

[@amitgoswami9629]

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

[@yogeshpradhan8287]

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

[@vbAFun]

Yes you use dd-mmm-yyyy

[@yogeshpradhan8287]

thanks@@vbAFun

[@BYASDEVGOSWAMI]

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.

[@vbAFun]

Yes it can be possible please keep watching will upload very soon

[@BYASDEVGOSWAMI]

Thanks. I am waiting..

[@faheemahmed9380]

Sir module1 ke coding kaa. Nai krta he

[@aIimranali]

Sir, i have download this file but the file is not running with vba?

[@tayyabatfarms]

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

[@vbAFun]

Great feedback, will now upload in parts thank you for your support and share this video

[@allvanity8147]

Good evening sir , any updates about the 26th ..... To the copy area

[@vbAFun]

Yes,i will correct the video or simply open the code and add in the last of control name .value for the date field

[@sunilmajithia1106]

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

[@mustafeosman1]

Thanks sir. How sum more than one account?

[@arizontradingandcontractin8541]

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

[@LubabaFouzan]

Hi sir, pls help me Todays / Current date entry not show when i search transaction please solve this.... thanks

[@yogeshpradhan8287]

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.

[@vbAFun]

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

[@alializadeh8195]

ممنون

[@alshahidjumah4304]

Abnormal .. Thank you very much..

[@vbAFun]

I appreciate thank you

[@aqeelahmad1764]

Superb A1

[@vbAFun]

Thank you

[@MohAboAbdo]

Thanks

[@shikshadeepvidyalaya6508]

जिस तरह हम last row find करके डाटा add करते है क्या हम लास्ट column find करके fix row में डाटा add कर सकते है ?

[@vbAFun]

Yes I have also show that in advance data entry video

[@AM-jd3rs]

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 .

[@vbAFun]

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

[@AM-jd3rs]

@@vbAFun thanks sir. You always reply our question. Thanks a lot. Great.

[@vbAFun]

Thank you for your support and comment

[@yogeshpradhan8287]

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

[@vbAFun]

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

[@imranshahzad9690]

Sir can u create voucher form Dr and Cr

[@vbAFun]

Yes it can be thank you for your suggestion

[@allvanity8147]

Thanks alot for your time but The from 26th transaction does not copy to copy area, that it work only 1 to 24th

[@vbAFun]

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

[@allvanity8147]

@@vbAFun noted Thanks Waiting for the update thanks alot

[@allvanity8147]

@@vbAFun please any update about 26th .... Copy area

[@ANIRBANROYCHOUDHURY-l5p]

Sir all account ka summary kaise create hoga, is par ek tutorial dijiega. Thanks in advance,

[@vbAFun]

Yes sure

[@RAJUKUMAR_SUHANI]

Amazing sir. Account opening open eala vedio means isse pahle eala vedio ka link bhejiyega sir

[@vbAFun]

Please search running balance on my channel video

[@lalitpatil5375]

Nice sir, Mujhe Account no ke niche Account Name chahiye to kya kare

[@SUNILVISHWAKARMAActor]

Kindly respond how to run यूजरफोर्म on office 2021

[@vbAFun]

You just open excel and open VBA editor and double click on userform then press F8 or just click on play button

[@abddulkuddusdewan9474]

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.....

[@vbAFun]

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

[@ramkrishnatvs4453]

KYA AAP AISE SOFTWARE BANAKE DE SAKTE HO? PRICE?

[@vbAFun]

Ye software free hai agar apko customise karbane hai to please insta pe contact kijiye

[@sunilmajithia1106]

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

[@vbAFun]

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

[@sunilmajithia1106]

@@vbAFun sir apka hi ek vide me dikhaya gaya he humne sikh liya kese open karne ka thanks

[@sunilmajithia1106]

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

[@dilipbiswas166]

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

[@vbAFun]

Hi thank you but fir plan karke coding karni hogi. So keep watching and try to understand method

[@dilipbiswas166]

@@vbAFun ok

[@tech11.786]

Hello sir 5.5+ 1.5 user form me kaise add and subtract please reply me

[@vbAFun]

You just use control name and + sign

[@bhavuvekariya8447]

Sir statment nahi araha hai please help me

[@vbAFun]

Statement ke liye abhi recently ek video dala hai us method ko bhi aap use kar sakte hai

[@rajibhasan8883]

Sir, Make a video about restaurant management.

[@salman12basha]

Sir isme edit option k code kaise kare

[@vbAFun]

Aap transaction edit nahi kar sakte apko reverse entry Lena hoga jaise journal entry karte hai

[@worldinfoo]

Store inventory software..

[@kamleshkc535]

Sir possible nahi he today wala data update ho

[@allvanity8147]

Which part of the code pls

[@vbAFun]

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

[@allvanity8147]

@@vbAFun please I only speak English Thanks sir

[@allvanity8147]

Pls can type it for so I can update ma file Thanks very much

[@lakhindrakumaryadav1276]

Sir, please update in this address option

[@roshanfernandes4534]

👌

[@waqasahmad-pt8ze]

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

[@sunilmajithia1106]

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

[@setyoufree2726]

Unfortunately.. not in English

[@vbAFun]

So sorry my English is not good

[@excelprofessional8505]

Sir, instead of using Sheet 2 several times better to guide us by With Sheet 2 'Code....., End With

[@kamleshkc535]

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

[@vbAFun]

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

[@kamleshkc535]

@@vbAFun nahi samje bhai aap batado nahi samaj me aa raha he

[@sunilmajithia1106]

@@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") = "

[@sunilmajithia1106]

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

[@vbAFun]

@@kamleshkc535 maine ispe Q & N ka video bana rakha hai usko dekhiye maine usme bata hai

[@allvanity8147]

Thanks very much Can you just update practice file with the code Thanks for that

[@vbAFun]

Please watch the video atleast one then check description you will get the link

[@yogeshpradhan8287]

Sorry, I hope i am not disturbing you too much

[@yogeshpradhan8287]

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") = "

[@vbAFun]

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

[@yogeshpradhan8287]

@@vbAFun right Ajayji thanks I'll try

[@roshanfernandes4534]

Sir Mujhe Ek Excel Formula chahiye Bahut try kiya samajpe nahi a araha hai Please help me How i can contact you.

[@vbAFun]

Kis Kam ke liye formula chahiye ?

[@roshanfernandes4534]

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

[@roshanfernandes4534]

Sir I'm Expecting Reply from you..!

[@vbAFun]

Please contact me on instagram

[@roshanfernandes4534]

Dear sir Your so kind and I really appreciate your help on my project file. Thank you so much for your immediate response.