Create Ledger of Accounts in Excel VBA | Generate Statement with Opening Balance & Export to PDF

[@subbarao25]

Every video of yours is just like an encyclopedia to learners I am one among them. Very very informative and useful for any businessman . Thanks a lot I look forward many more useful video's

[@vbAFun]

Sure sir and thank you for your comments, it really helps us to create more useful tricks

[@mdmahibul-z4r]

Sir you're great vba traininer all of world ❤

[@vbAFun]

Thank you so much

[@herbalifeindipe.asso.7039]

Excellent Bahut hi Badhiya I'm waiting to next video thank you sir 👌👌👌🙏🌹

[@vbAFun]

Thank you

[@anandpawar8875]

bahut achya sir,

[@vbAFun]

Thank you

[@nectarshrestha31]

Excellent sir

[@alializadeh8195]

Thanx

[@indianmonster1445]

Sir cash Ledger complete & clean hai ….perfect 🎉🎉🎉🎉🎉 Sir aap Purchase Order application kab banao ge :- * purchase order system : create/edit/ delete/update etc. control * No. Of item limitations 1-400 tak chalega * purchase order tracking system * purchase order data recode items wise PO vise. * purchase order save as PDF

[@MyMobiletone]

Sir bill wise payment jama karena vba ne video banay Ek sath three bill payment aaya or party payment bhi aaya to ke che jama karen ke ve sa video banay

[@abddulkuddusdewan9474]

Dear Sir, nice report, but could u pls. Include decimal.....for number?

[@souravgupta9775]

Sir, agar mere pas bohot party ya item ho to party /Items wise cash ledger kese generate karna hai uske upar agar lecture rakhange to accha hota.

[@vbAFun]

Thanks will create that

[@sethowusuagyeman]

I love this tutorial But is there a way you can edit the denomination units when the transaction is OUT not IN

[@vbAFun]

When you collecting the cash then how the computer know which denomination you have

[@sethowusuagyeman]

@@vbAFun Thanks for your reply. But i am referring to a situation where i am making a payment where i have to record each denomination i issued out. For example; i have 20000 total cash but in various units and i want to pay 500 out. But i paid the 500 using the 20s, 10s but not the first denomination. i hope you understand my question.

[@sethowusuagyeman]

Is it possible to change or edit the denomination when the Get Denomination is clicked so that i can choose other denominations as well to make up the total i want to pay out

[@sethowusuagyeman]

@@vbAFun When i am paying out, i a have the denominations already so i should be able to select which denomination i paid out after clicking the Get Denomiation Button

[@jitendramahapatra1239]

Sir kya jewellery stock check karne keliye barcode scanner ek software bana sakte hai Jaise hum jewellery stock check kar sakte hai

[@khadimhussainmomin1315]

go ahed great isme pdf file date k naam se save ho ye please bataye aur date me ek aur validation daliye k agar end date hammesha start date se bada hona chahiye for exam. agar start date 01-jan-2024 hai to end date january se niche ka nahi hona chahiye jaise 31-Dec-2023

[@vbAFun]

Already isse related video upload hai but fir se banayenge

[@khadimhussainmomin1315]

ok

[@prahladsahu-lt8np]

Vba ke liye ms office genune hona jaruri hai kya sir mere me date picker kaam nahi kar raha hai

[@vbAFun]

Nahi aisa jarurat nahi hai

[@lalitpatil5375]

Sir, Ek Statement hai - CrAmt and DrAmt with sumifs statement - apne StDt Credit Amt and Debit Amt me same liya leking age chalke jab if condition with StDt and EnDt , ati hai to Type mismatch error ati hai DrAmt me EnDt hone chahiye yes or no ------ DrAmt = WorksheetFunction.SumIfs(.Range("E:E"), .Range("G:G"), "OUT", .Range("B:B"), "

[@mannaavlog1250]

Sir withdraw ki bjae deposit ae ga shyd

[@vbAFun]

You can add anything

[@Mannabhav]

❤🎉❤🎉

[@dheerajpaliwadheeraj6685]

Party ledger make video

[@vbAFun]

Sure but you can use thi method for any type of ledger creation

[@raghunathsah5241]

Sir tally prime jaisa userform banaye please sir

[@markandeyagorantala2787]

Yes sir tally prime jaisa software banayiye

[@raghunathsah5241]

Thanks sir ji

[@VisualKreation]

Nice and interesting Sir, Get Deonomiation per click karne ke bad next currncy dikhana chahiye samhi ki 1000 Rs ka 500x2 or click kare to next 200x5 aise dikhana chahiye jab tak 1000 Rs equal ho to exit hona chahiye. aisa ho sakya hai ?

[@vbAFun]

Haan pahle big denomination konuthata hai usse pura nahi hoga to dusra count karega

[@VisualKreation]

@@vbAFun Yes Right

[@chandankumarverma8148]

Sir ji mai aapka video se bahut kuchh shikha hu guru dev bs mujhe samjh nhi aa raha ki login page jisame login hone k bad success ka msg aur sound aaye aur password false hone pr msg k sath incorrect ka sound aaye esa koi code ho to bata dijiye sir aapka aabhari rahunga 🙏🙏🙏🙏🫡🫡🫡

[@vbAFun]

Speaking software ke name se maine video bana rakha hai please check that

[@Priyam5]

आपसे बहुत कुछ सीखा Thanks ❤️

[@shaileshsharma668]

Sir ek video yese upload karo do plz jis par hum Google sheet se connect kar sakte

[@vbAFun]

Google sheet se data ko fetch kar sakte hai

[@shaileshsharma668]

@@vbAFun sir mujhe upload karna hai real time jaise Maine ek entry ki one entry append ho jayega Google sheet par jaise mai kuch dashboard bana saku real time par

[@vbAFun]

Uske liye aap appsheet ka use lijiye

[@shaileshsharma668]

@@vbAFun sir yesa kyo tarika nhi hai ki mai sidha Google sheet par data append kar saku without using appsheet

[@vbAFun]

Yes aap Google sheet open karke data save kar sakte hai

[@Gandaki_News]

Maximize api

[@syedshahzaibali4729]

We need have an option, what if we need to pay someone 480/- and dont have change. We should pay 500/- and get back 20/-.

[@bikram903]

Sir please ek is tarah video banaiye please excel userform:- kzbin.info/www/bejne/j6TdfXR6m7aFb9Esi=oGUGqqI6PSltrvau

[@vbAFun]

Okay will show

[@muhammadhanifsoomro3166]

Sir very useful video ۔۔but how to export PDF with customer name ۔۔۔

[@vbAFun]

You just change the path and keep name with customer textbox name