Build an Amazing Inventory System in Just 1 Hour | Excel VBA Userform
HTML-код
- Опубликовано: 18 авг 2022
- In this video, we will be developing a basic In/Out Inventory System using the Excel VBA User form.
It is exciting to know that you can create a basic Inventory System using the Excel VBA user form. The great news is that you can build this tool in less than an hour.
Template Link: github.com/happycodingandlife...
Download this template with a pre-build design, so you don’t need to start from scratch. You can modify some of the controls depending on your need.
Wow! thank you for this! this is very helpful since i'm planning to create an inventory system in our office! (only have small macro background tho) Looking forward to more videos like this! :)
Well-explained and easy to follow! Thank you for sharing us your skills sir. These tutorials are very helpful in our workplace! Godbless you
dear engr Thanks a lot u are just amazing. Can' wait to watch your next videos for teaching us any other automation tools. Thank you so much.
You are just amazing. Can' wait to watch your next videos for teaching us any other automation tools. Thank you so much.
More to come!
@@LoveCodingAndPlay I see the template but not the final code that you video taped. Anyway to share that also. having trouble getting this to work. Thank you
I subscribed. From Philippines
Its great Video, Thank you
Super cool set up. I was curious. I already have an active inventory list with over a thousand items. Using your template would there be anyway to link the product information to this?
First of all I want to thank You very much for sharing your precious knowlwdge!
I'd like to tell you that I found a pair of little bugs in the code you shared.
I think that the formula for total price should be the following:
'Total Price
Dim totalPrice As Integer
totalPrice = newstocks * price '
This is very helpful. can you make another video on how to edit data with "Edit" button, delete data with "Delete" button and also print on specific date with "Print" button? Thank you very much!
Superb, 💝💝💝💕💞💞💞💕
Thank you❤❤
Hi, can you show how to add button in that template with update, edit and save? in that project that you made? please? because i need it, and it so very helpful
Sir
Superb
Amazing
I have one question
Will you made inventory system with day by day opening closing stock of all products?
If you wanted to delete some items, can you delete it directly in the worksheets without affecting the vba codes???
in your inventory template. can you update it, and added a feature with the product serial number? how about you have multiple qty in a single product. to register it with an individual serial number, how do you update with that?
Hi,
Thanks for Teaching me and making me update. it was really amazing to learn in easy way.
but i have one quire.
When we delete the entry from add items why it's not taking ID in continue way?
(Exmple:- If I have adding 10 items and if i want to delete the 5th entry then below number are not coming in sequence)
So just update me can we make it possible with VBA
Hi Sir, the total variable not run display on form and cell?
Good day sir,
How about the function of ====.end(xldown) or (xlLeft) or (xlRight). function with the same system inventory?
I hope you see my comment thanks in advanced.
Great work. Please, can I have the download link for the template?
Don't download it, it's a Trajan virus
Nice Software, Please can you send me the running software, no need for any edition
Hey i do not want to add price to my items but i cannot add them without price
Hey i got error 1004 for “for a = 3” part 😢
hello sir, ask po sana ako kung meron na kaung complete na po?? bayaran ko na lang po kung ok lang thank you
why is my form having error saying error 6 Overflow ?
How i will make it google sheets
Hello bruh,
How to customize this template, i need to change small changes for my purpose, mainly i need to change the text box color..
You can download the template and press ALT+F4 and you can customize the userform
What if need niyo po mag delete ng product? paano po yon?
Hello sir kmusta? Your video is very useful kasi just learning to use vba. How can i download your template? Salamat
Okay na okay naman po, thank you po sa feedback... nasa link po yung github link to download the template.
where the template?
The xlsm file doesn't open. Excel says it is corrupt. Can you please help?
I just downloaded it and its not corrupted, maybe your system is blocking the file because of the macro
Could anyone please share the template link. The link in the info does not work
please check the new link in the video description
I am having trouble with lastRow = (“A”& Rows.Count). End(xlUp).Row…keeps returning as an error I have tried everything
me too :(
Me too, did you solved this issue ?
Can you help what is the code for this i have USERFORM it has seven field student id, student name, once I enter data and click save it will be added to the student listbox and to worksheet, my question If I have an other file of excel and I don't want to manually type it in the userform and added to worksheet of userform, I need code to add button in userform that once I click it will select different excel file that with same format of worksheet in the userform and once I upload or import this file it will automatically appeared in the userform field of data entry also appeared and save to the worksheet of userform and added to the userform listview? I hope you read this i believe it is interesting and big help thanks in advance. More power
yes that can be done easily in VBA, you can use Application.Open to browse for a different excel file and use a workbook variable referencing the other workbook using its path. Then you can just simple loop thru the other workbook data and add it to your main workbook.
@@LoveCodingAndPlay thanks sir I will try and I hope to succeed it because I just start to learn only in watching RUclips and 60% of posted programming VBA is not working it has trick only and I search sample programming for this but unfortunately no one try to that mostly is manually typing only to userform.
Great job but not average cost !!!???
can i use your video?
Sure
@@LoveCodingAndPlay Thank you So Much! You are great
Hi bro,
Can we get the code?
Thank you
its in the link bro
i see the template but where is the actual final code for this project. i tried following along and i get errors. Thank you for sharing
@@LoveCodingAndPlay can i have the link?
why mines not updating sa main kapag nag fill out sa product :
Check natin? Call?
hi
Have any contact.i have a some issue in my code
you can email me at happycodingandlife@gmail.com
Send the mail
Hi Sir, hindi po ma download yung template, salamat
Sir, i send you mail can we have connect ? . Thank you
Sent you an email