Well lots of regards to all members of this forum.....The Best I have come across.
I have a very basic workbook for inventory control for my shop. just have to give some finishing touches to it.....Thanks to you all for your help.
Among many other user forms and command buttons in the workbook the following three (although they work fine and give the desired results) Run VERY SLOW.
Maybe its got something to do with the codes.
I need to speed up the codes and streamline them.
1) "Day Close" command button.......This closes the day, copies the sheet to a new worksheet with the current date, and clears certain ranges etc
2)"Update and Add" Command Button.......This updates, adds new items to the inventory and can modify certain values etc
3) "OK" command button........During counter Sales the sold items, quantity, their rates and total sale amount is registered in the Registry section for further action.
All these codes are functional and give the desired output, but i am not satisfied withe speed of operation.
Please if possible can someone see if there is any room for modification and streamlining of the codes.
I am attaching the workbook for your reference.
Ill be grateful, as i need to implement this in my shop at the earliest.