How to Create Inventory Management Systems in Excel using VBA

[@kelelo1488]

This was really helpful and straight to the point thank you!

[@DJOamen]

👍

[@jahidulrahaman8365]

Boss, i need a laboratory invoice, patient registration, Dr commission, reporting management system in a small clinic, please post it

[@DJOamen]

Is already done (Excel Hospital Management System), you just have to look for is on my channel. Use the channel Playlist to filter the videos. kzbin.infovideos

[@algamdie]

I cant found date and time picker tool in additional controls . how can I get it?

[@DJOamen]

You can tell if you already have the new date picker installed by following these steps: With regards to Microsoft Date and Time Picker, see the my findings below: excelribbon.tips.net/T002080_Installing_the_Date_Picker.html Display the Developer tab of the ribbon. Click the Insert tool. Excel displays a palette of tools you can insert in your worksheet. In the ActiveX Controls section of the palette, click the More Controls option. (It is the very bottom-right tool.) Excel displays the More Controls dialog box. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool. Select it. Click OK. If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system. If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems. (In fact, none of the ActiveX controls work in 64-bit Office. When Microsoft actually comes out with versions of the controls that do work with 64-bit Office, they will likely have different names, a move sure to complicate the life of VBA programmers who rely on the controls. If you are running a 32-bit version of Office, then you can try to copy the MSCOMCT2.OCX control from a like system and register it with Windows. (Before copying it, do a Windows search to see if the file is actually on your system. If it is, skip copying and just try to register it.) How you register the control depends on the version of Windows you are using and whether you are using a 32-bit or 64-bit version of the operating system. (Don't confuse the number of bits in the operating system with the number of bits in your copy of Office; they are two different things.) A good overview of how to register the control can be found here: