PoS (Point of Sale) in Excel - Part 2 | Barcode enable billing Software in Excel Userform

[@mustafeosman1]

Thanks you are the best 👍👍👍🇸🇴🇸🇴🇸🇴👌👌👌

[@vbAFun]

I appreciate🙏

[@shivannahr780]

Good morning sir thanks 💖

[@vbAFun]

Good morning and thank you

[@springandfallcolln]

VERY VERY NICE TEACHING. I WANT MORE TRAINING......

[@vbAFun]

There is lot of module keep watching and sharing

[@abcd2-k4s]

Achha laga Sir ji

[@vbAFun]

Thanks

[@Ranvir7910]

I watch all your videos and you teach very well that's why we don't miss a single video of yours but sir teach me how to make hospital patient registration form plz

[@vbAFun]

One this completed I willl start hospital patient management. Keep watching and thank for like, share and comment

[@Ranvir7910]

@@vbAFun ok sir thank u

[@GentleMen_Post]

Fantastic Sir, thanks a lot

[@vbAFun]

Welcome and keep watching and thank you for like share and comment

[@wahdateummattv]

Very nice you have a nice day

[@vbAFun]

Thank you! You too!

[@simplydoing9596]

bhayya ji, Totat, net, disc. dikhane ke liye jo aap Textbox liye he Uski Jagah Label lete toh Kitna accha hota 1. benefit - BLACK TEXT DIKHTA. 2. benefit- any editor by mistake can't enable it So aisa kar sakta he kya ? Kyonki VBA me Everything can be loaded with TEXT

[@bharatiyahooner]

Amazing sir

[@vbAFun]

Thank you

[@newlearn508]

Great 👍👍👍👍👍👍

[@vbAFun]

Thanks

[@ravindrapatel4591]

Great sir

[@vbAFun]

Thank you❤

[@bh3724]

Hi There, Thanks for video. It's really useful. I have an issue that there is no any information showed up on Listbox1 as your video but tempsheet. How could i fix it?

[@wahdateummattv]

Very informative videi

[@vbAFun]

Glad you think so!

[@tuniyatraders6817]

hello sir fantastic, sir plz make video genrate barcode. and printing pos invoice plz

[@vbAFun]

Thank you very much for your comment, like and share. Sure this is in my list I will make soon

[@PiyushMedicalKnowledge]

Good video keep up

[@alializadeh8195]

Thanks

[@lavucom4922]

Nice..

[@vbAFun]

Thank you! Cheers!

[@excelshambhu]

Great work sirji

[@vbAFun]

Thank you

[@intakhabkhan9649]

Thanks for continue uploading the video, part 2 bhi bahut achha laga sir.

[@vbAFun]

Thank you❤

[@H---BSnehaDas]

Sir aap tax invoice ka format agle vidieo pe de dena.matlab POS ka invoice format.

[@vbAFun]

Okay will try to make

[@H---BSnehaDas]

@@vbAFun Thanks Sir

[@safwankhan7779]

apki ek video thi employee user form pr, tw mene pehly vo ready kia phr mene ussi userform p multi page me ek or section add kiya jismy inventery add hosaky lekin vohi same coding use krha hn lekin work nh krha

[@vbAFun]

Please watch carefully and try that will work

[@MegaPrakash22]

Thank you for great knowledge sir. 👏 Sir, I have a request. Right now in payment section it accept the amount less than net amount. Should we make the payment section couldn’t accept the amount less than net amount?

[@vbAFun]

Thank you will update it in next part, thank you for your comment, like and share

[@satishmandlik9724]

Sir, pos bill amount 1000 hai, usme agar koi grahak 300 rs Google pe, 500 rs Credit card aur balance 200 rs cash se paid karta hai to kaise bana padega? Iska ek video banaiye please 🙏🙏🙏

[@H---BSnehaDas]

To mujhe banane pe bohoti help hota Please Sir.

[@vbAFun]

Mai ispe ek alag se video bana dunga abhi ham dusre project pe kam kar rahe hai

[@H---BSnehaDas]

OK SIR

[@ertugrulguven4965]

PoS (Point of Sale) in Excel - Part 2 | Barcode enable billing Software in Excel Userform First of all, thank you very much for such a useful work. I couldn't do the name manager operations in Excel, which you did between 3:28 and 04:30 of the video whose address is written above. Could the reason be the Microsoft Office 2007 version? By the way, I can send you the part where I worked. Or you can examine this application and its code structure. Can you send it? Best regards.

[@pcsolution1504]

How to search by invoice no ???? Please add

[@Muhammadhasnain658]

Sir jesy apne product ko code sye enter krwaya agr name likhne sy krwana ho tu kia krein Kindly help me to solve this prob.

[@MRazzaqYouTube]

Jab list box Khali to delete button dabany per offset formula delete ho jata hai

[@vbAFun]

Yes ho sakta hai, iske liye last row ko check kijiye or condition dijiye ki last agar 2 se kam ho to delete na kare

[@MRazzaqYouTube]

Thank you sir selrow=me.listbox1.listindex+3 Is code ke aghy ker na he selrow=me.listbox1.listindex+2 Sar Ham se kam kar rahe hain to please sir hamen sirf iska HAL nikal Kar de de

[@MRazzaqYouTube]

Sir me ne TRAI Kiya hai Lekin mujhse se Nahin hua to please sir mujhe iska HAL nikal kar de de please

[@jaseem12]

Thank you, i couldnt find the final part?

[@vbAFun]

Please watch bux fix pos for final copy

[@jaseem12]

@@vbAFun thank you sir. I have some errors on the changes. It's unable to get the values from the sheet4 change cells

[@safwankhan7779]

can we make multiple data entry userform in single file,

[@vbAFun]

Yes you can make please watch multi user software video

[@safwankhan7779]

thanks, But can you give me the link to that video? I looked many times but couldn't find.

[@relaxmybrother4047]

Sir, after scanning item i want to scan the second item but first i have to delete the barcodenumber. Is there a solution to delete automatic after scanning the first item. Thanks

[@vbAFun]

Yes in this tutorial u made that

[@abduljamilafghan2464]

Hello sir If I want to add the sum total of this invoice to the same customer and then in New invoice and the previous ledger and balance amount of a customer, running balance amount of the following customer in this invoice In this case what kind of code we should write for And minas the selected products from running balance of stock Cane you explain this sir please

[@nammarcr33737]

Hi sir how create items without scan , item qty rate this three should be manually entry then amount should be auto entry I needed pls

[@nammarcr33737]

Set itm = sheet 2.Range("A:A").find(Me.itmscan.value, XlValue.XlWhole) Without scanning the itm,qty,rate, I needed manually entries Pls solve my query

[@qualityquest6783]

Sir, Very informative and worth learning video, Thanks for sharing such valuable information and teaching. but I have a glitch in calculation at the Rows J to N where, the Formulae of Net Amnt {=(J2-K2)} and Change{=M2-N2)} are getting cleared/over written with value once the scan code is entered. the first row of item list box value clears the Formulas from the Cell L2 and N2. I am stuck at this point.

[@vbAFun]

Hi thank you for your support and comment, i have to see this if there is any calculation glitch please run code step by step and check on which line of code is clearing

[@muhammadnaveedgill8784]

Sir Sath ma Data bi save krna batya

[@vbAFun]

Data save hota hai isme jab aap print krenge to data save ho jayega. Please complete episode

[@goyal383]

Aapke 2 nd video mai userform listbox1 kese add kare

[@vbAFun]

I have explained every thing in video please watch

[@srimalruwan]

How to stop the mouse from automatically moving to the next text box while scanning an item with a barcode scanner. There is no problem when typing with a keyboard. But when scanning with a scanner, it automatically goes to the text box

[@vbAFun]

Use exit event

[@nasrisabtal5281]

Sir, I have a problem whenever I type my barcode(1001) in scan item the price label disappear and the first one does not go in list box while the next item display in list box. There is no problem in the temp sheet.

[@vbAFun]

Please watch video carefully and follow the same

[@azizurrahmansaad7157]

Sir why my items not coming in Listbox.There is only name’s coming but other 4 are not coming. Plz help

[@vbAFun]

Hi please watch video carefully and try you can also download practice file

[@kuldeepvishwakrma5761]

Sheet4.Range(SelRow & ":" & SelRow).EntireRow.Delete is Not working this line become yellow and Msg come Delete method of Range Class Failed

[@abhaykumar904]

Sir watched your school management system video and create as well but when I transfer that file to another system it gives error. What are causes of that error I can't find? I assume that Library may not be enabled but it showing that main page missing.

[@vbAFun]

Click on the debug and check

[@abhaykumar904]

@@vbAFun it indicating that main page is missing but I double ensure that file is available and run individual main page. Is is possible that different excel version affect that??

[@vbAFun]

I think no there is no issue with excel version. In this programme I have used default references

[@wahdateummattv]

Very informative video thanks a lot

[@abhaykumar904]

@@vbAFun I don't know sir, can I share you that file after completing project?

[@modalmalek4039]

1 se 100 % tak discount dalna he to kese kare

[@sampath9150]

Sir, mere excel me itemscan se lekar kaam nahi kar raha he error batha raha he. Itemscan apka jesa same userform mene banaya usme itmscan code error msg aa raha he.sir, can you plz explain me why it coming

[@vbAFun]

Hi please check in code by just running step by step code ki kaha pe error aa raha hai

[@pcsolution1504]

Please add bill no search to print next time

[@fazlurehmannh]

Can you please upload the code file, so as to understand it better. Please

[@vbAFun]

Yes sure find the video PoS bug fix and check description

[@neeleshkushwaha5561]

Sir "userform me sabhi textbox filled ho agr sabhi textbox me koi na koi value na ho to error ka msg de" Esa kaise kare Please

[@vbAFun]

Iske liye if ka condition use kar sakte hai aur mere sabhi video me apko is tarah ka milega ki agar koi textbox khali ho msg aayega. Please keep watching and thank you

[@neeleshkushwaha5561]

@@vbAFun sir link de dijiye please

[@vbAFun]

Go to channel and watch the video and download the link from description

[@kishanpatel3168]

How to save this in between

[@topersubha2924]

List box me khali item ka nam a rahi ha or kuch nahi arhi ha

[@munnasarmas]

sir E drive me pdf save ho raha he E drive me ek folder ke ondor keise save kore plz code digiye

[@vbAFun]

Folder path Dena hota hai iska ek separate video banunga

[@munnasarmas]

thankyou sir

[@goyal383]

Aapka teper sheet mai refrence thik se show nahi ho raha

[@vbAFun]

Oh okay please download file from bug fix video of pos

[@LalitmohanPradhan-bl2zf]

Listbox1 how to make, could not noticed

[@vbAFun]

Will upload ye new video with in same format

[@AbdurRahman-ns7ru]

Direct listview kaise hoga

[@vbAFun]

Direct listview se kya matlab hai

[@AbdurRahman-ns7ru]

@@vbAFun textbox se listview mai add ho jaye without temporary sheet banaye

[@harryharry2109]

How to edit invoice after saving??

[@vbAFun]

You have to recall the item bit in this application this facility has not given

[@bvsubramanyam5191]

give the userform or code in pdf. what u type is not seen clear.

[@vbAFun]

Thank you for your feedback, I have given the file link in big fix of pos video. So please download and try to make

[@sumitpayra8232]

Sir, I want this file, please.

[@vbAFun]

You can download from part 3

[@sumitpayra8232]

Ok sir.

[@rajeshkumarchaturvedi7006]

VBA description me dale Barbar change karte ho

[@vbAFun]

Hi sorry for inconvenience but please check the description of final video part 3

[@AmirSohail-sf1jl]

Offset formula zoom kren.

[@vbAFun]

Name range ka ek video latest hai use dekhe

[@AmirSohail-sf1jl]

@@vbAFun link pleas

[@onlineforminfo2270]

are yaar aise kon batata hai ek dum bekar kuch samjh aa raha kuch nhi

[@vbAFun]

Sorry for your inconvenience, mai koshish karunga aur asche se batane ka, long video hone ke karan ho sakta hai thoda fast ho gaya hoga, aap iske speed ko slow karke dekhenge to samjh aayega

[@onlineforminfo2270]

Wo discount ke baad net Amt kaise change hoga ho hi nhi Raha hai userform me or na hi payment change ho raha hai sheet pe ho jata hai user form per nhi hota hai

[@onlineforminfo2270]

New invoice click karne per listbox me fir item show nhi hota hai

[@vbAFun]

Aap agar step by step video dekh ke uske anusar coding dekhenge to error nahi aayega

[@onlineforminfo2270]

bahut time laga hai banane me jara sa help kar dijiye

[@ChakravarthyPVVP]

sir, in the invoice out put the listbox is just displaying item name and not getting the other 4 values. can you please tell me where I am doing wrong, the formula in the name range i used as =OFFSET(TempSheet!$B$1,1,0,COUNTA(TempSheet!$B$1:$B$9999)-1,5) and the below is the code and I will share my excel sheet, please share me ur email id. Private Sub Itmscan_Change() Set Itm = Sheet2.Range("A:A").Find(Me.Itmscan.Value, , xlValues, xlWhole) If Itm Is Nothing Then 'do nothing Else 'Add Items in boxes ItmRow = Itm.Row Me.Itmname = Sheet2.Range("B" & ItmRow) Me.Mrp = Sheet2.Range("C" & ItmRow) Me.Price = Sheet2.Range("D" & ItmRow) Me.Qty = 1 'Item Add in TempSheet With Sheet4 NewRow = Range("A9999").End(xlUp).Row + 1 .Cells(NewRow, "A") = Me.Itmscan.Value .Cells(NewRow, "B") = Me.Itmname .Cells(NewRow, "C") = Me.Mrp.Value .Cells(NewRow, "D") = Me.Price.Value .Cells(NewRow, "E") = Me.Qty.Value .Cells(NewRow, "F") = .Cells(NewRow, "D") * .Cells(NewRow, "E") On Error Resume Next Me.ListBox1.RowSource = "Itemlist" End With 'Add item in List Box End If End Sub Private Sub NewInvbutn_Click() Me.Inv = Application.WorksheetFunction.Max(Sheet1.Range("A:A")) + 1 Me.datetxt = Format(Date, "dd-mm-yyyy") Me.Itmscan.SetFocus End Sub

[@vbAFun]

Code is correct please check sheet no is correct or not . Again if you are getting error please run code one by one by pressing f8 and check why you getting the error

[@ChakravarthyPVVP]

@@vbAFun Thank you sir, every thing was ok but the list box value was set to zero, now I changed it to 5 then could acheive the result. Keenly watched your video and it helped me.