PoS (Point of Sale) in Excel - Part 2 | Barcode enable billing Software in Excel Userform
Vložit
- čas přidán 4. 09. 2021
- PoS (Point of Sale) in Excel - Part 2 | Barcode enable billing Software in Excel Userform
Hindi
Hello friend today I have uploaded part 2 of the Point of Sale (PoS) in Excel.
In this video you will learn a new trick to add item in Listbox, Update Item quantity and Delete.
Our Aim :
Provide support in vba in Excel
Support to create Excel Application Development
Provide Free Excel Vba Training
Our Playlist :
Business Applications playlist
• Small Business Applica...
Employee Manager
• Employee Manager
School manager
• School Manager
DatePicker :
• DatePicker
Facebook : profile.php?...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
#ExcelApplication #Excel #PoS
![Automated Invoice and Stock [ Inventory ] Management in Excel - Inventory Management in Excel](http://i.ytimg.com/vi/bSDGrRtNcdk/mqdefault.jpg)
Thanks you are the best 👍👍👍🇸🇴🇸🇴🇸🇴👌👌👌
I appreciate🙏
Good morning sir thanks 💖
Good morning and thank you
Great work sirji
Thank you
Fantastic Sir, thanks a lot
Welcome and keep watching and thank you for like share and comment
VERY VERY NICE TEACHING. I WANT MORE TRAINING......
There is lot of module keep watching and sharing
Achha laga Sir ji
Thanks
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?
Thanks for continue uploading the video, part 2 bhi bahut achha laga sir.
Thank you❤
Great 👍👍👍👍👍👍
Thanks
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
One this completed I willl start hospital patient management. Keep watching and thank for like, share and comment
@@vbAFun ok sir thank u
Very informative videi
Glad you think so!
Good video keep up
Thanks
Very nice you have a nice day
Thank you! You too!
Great sir
Thank you❤
Amazing sir
Thank you
Nice..
Thank you! Cheers!
Sir aap tax invoice ka format agle vidieo pe de dena.matlab POS ka invoice format.
Okay will try to make
@@vbAFun Thanks Sir
To mujhe banane pe bohoti help hota
Please Sir.
Mai ispe ek alag se video bana dunga abhi ham dusre project pe kam kar rahe hai
OK SIR
hello sir fantastic, sir plz make video genrate barcode. and printing pos invoice plz
Thank you very much for your comment, like and share. Sure this is in my list I will make soon
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?
Thank you will update it in next part, thank you for your comment, like and share
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 🙏🙏🙏
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.
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
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.
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
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.
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.
Please watch video carefully and follow the same
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
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
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
Please watch carefully and try that will work
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
Yes in this tutorial u made that
can we make multiple data entry userform in single file,
Yes you can make please watch multi user software video
thanks, But can you give me the link to that video? I looked many times but couldn't find.
Aapke 2 nd video mai userform listbox1 kese add kare
I have explained every thing in video please watch
Sir Sath ma Data bi save krna batya
Data save hota hai isme jab aap print krenge to data save ho jayega. Please complete episode
Sir why my items not coming in Listbox.There is only name’s coming but other 4 are not coming. Plz help
Hi please watch video carefully and try you can also download practice file
How to save this in between
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.
Click on the debug and check
@@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??
I think no there is no issue with excel version. In this programme I have used default references
Very informative video thanks a lot
@@vbAFun I don't know sir, can I share you that file after completing project?
Thank you, i couldnt find the final part?
Please watch bux fix pos for final copy
@@vbAFun thank you sir. I have some errors on the changes. It's unable to get the values from the sheet4 change cells
Can you please upload the code file, so as to understand it better. Please
Yes sure find the video PoS bug fix and check description
Sir Ek problem ho raha hai tem sheet me change field me bar bar calculation wrong ho raha hai pls help kare thanks in adv
Hi thank you for your comments please check code step by step debugging
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
Hi please check in code by just running step by step code ki kaha pe error aa raha hai
1 se 100 % tak discount dalna he to kese kare
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
Use exit event
sir bar bar change ka formula N= M- L DELETE HO RAHA HAI
Listbox1 how to make, could not noticed
Will upload ye new video with in same format
How to edit invoice after saving??
You have to recall the item bit in this application this facility has not given
sir E drive me pdf save ho raha he E drive me ek folder ke ondor keise save kore plz code digiye
Folder path Dena hota hai iska ek separate video banunga
thankyou sir
Sheet4.Range(SelRow & ":" & SelRow).EntireRow.Delete is Not working this line become yellow and Msg come Delete method of Range Class Failed
Sir, I want this file, please.
You can download from part 3
Ok sir.
Aapka teper sheet mai refrence thik se show nahi ho raha
Oh okay please download file from bug fix video of pos
Direct listview kaise hoga
Direct listview se kya matlab hai
@@vbAFun textbox se listview mai add ho jaye without temporary sheet banaye
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
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
@@vbAFun sir link de dijiye please
Go to channel and watch the video and download the link from description
Offset formula zoom kren.
Name range ka ek video latest hai use dekhe
@@vbAFun link pleas
give the userform or code in pdf. what u type is not seen clear.
Thank you for your feedback, I have given the file link in big fix of pos video. So please download and try to make
VBA description me dale
Barbar change karte ho
Hi sorry for inconvenience but please check the description of final video part 3
are yaar aise kon batata hai ek dum bekar kuch samjh aa raha kuch nhi
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
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
New invoice click karne per listbox me fir item show nhi hota hai
Aap agar step by step video dekh ke uske anusar coding dekhenge to error nahi aayega
bahut time laga hai banane me jara sa help kar dijiye
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
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
@@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.