Inventory System 101 In Excel VBA a Step by Step Guide to the Basics

Check it out!

Fantastic Developer Tools:

[MYJETGLO]

How good was that.  This is the type of VBA I really enjoy.  Interface work really shows the power of vba.  More of this please Dan!  Thank you for posting.

[emilygiguere]

Do you have a video for inventory cycle counting VBA (selecting multiple random locations that haven't yet been counted)?

[mrdy]

Another excellent video Dan, I loved taking part in that competition and looking forward to many more in the future.

[krn]

Thanks Dan. Another tip to center that userform instead if dragging it. In the userform activation event add
With Me
.startupposition=0
.left=application.left+(0.5 * application.width) - (0.5 * .width)
.top=application.top + (0.5 * application.height) - (0.5 * .height)
End With

This simple code will center yr userform every time.

[gpuandchill-relaxation]

Thanks for sharing.  at 18:49 you convert text to a number how would you convert text to a currency format?  Thanks so much for the help.

Chris

[netflixfree]

Hi! I have a question. WHat if I want to add other products? where do i edit within the code you provided?

btw this helped me so much on my term project <3

[Needforexcel]

Hi Dan! Any more contests coming up? I wish to participate too.. 

[NSLas]

Awesome! thanks .. #learned #refreshed my skills ..

[jetpaq]

Dan, I think you are wonderful. Just had a thought. Perhaps you can solicit a sponsor for your prizes, and be able to announce a great giveaway, without using your own money! Your videos deserve more praise and recognition, and ill bet it would be a great way to promote two things at once! -M Jetson-

[tygrrboi]

You should probably get out of the habit of using "A:A" as a range and limit the number of rows you are referencing (for example, use A1:A1000). If your file gets very large, searching entire columns slows down the program.

[panagiotistheodorou]

The presenter is not organized and he confuses more than teaches anything....