Excel VBA - Orders and Inventory Management - Excel 2013 Part 5 Userforms

Excel VBA - Orders and Inventory Management - Excel 2013. In this project I'm going to show you how you can use userforms to run a complete order and inventory system. This is a training project series. You will learn how to use a userforms with dependent lists looking up data and transferring that data to worksheets. If you want to learn more about Microsoft Excel VBA programming this is a great project series feuded the involved with. Templates will be available from the website. There is so much to learn with this application. We will compare ordering against the infantry that we have in stock. So every time we place an order will be up to see if we have sufficient stock to be able to cover that order will also then be able to add new stock add new products add new customers. But the most important feature is that we can filter all this information over time by years or by months or by any criteria. Will be learning Excel VBA recording macros advanced filters formulas and much more.

[chanchhayyachap]

Dear Mr. Trev,
Thank you so much for your videos tutorial. I follow along with those videos.
I have found an error in your code to lookup the Unit Price. It's not in col_index_num 4, but it's in col_index_num 3.

[lalitpatil]

Please request you to describe goods received and order forms each fields
My problem is, not exactly run setmerec and setme procedure
In this procedure, I have problem - discuss= Val(me.txtOMum)

[nadeemhussain]

Trevor this is a very informative project but i'm lost after 5th part so kindly help me if you can upload for me a this complete project sample file here please

[TheLegendaryFinn]

What a great tutorial once again!


I have got two problems.

In Europe we use a comma instead of a dot in currency (1, 50 instead of 1.50). How would I have to change the code to get a comma there, and also make the sheet recognize it as number?

I have the same problem with dates. In Finland we use the format dd.mm.yyyy. I just can't get the code to format the date that way.

Your help would be much appreciated.

[Madnezz]

Shouldn't this Receiving stock form (Also Orders) update the Products Sheet ? Seems pointless to not update.

[tylerzens]

Mr. Trev,

I'm having an issue with the add stock button. After entering the proper codes and, i've checked down to the letter, I keep getting Error1004 popping up. And i can't get the dynamic named ranges to work after doing that code either. I haven't had any problems with these tutorials until this point. May i please get some help, sir?

[kwik]

Trev, careful on the spelling. A few times the word Receive you 've spelled differently. One received and the other recieved. Option Explicit I never leave home without it.