Hello everyone,
I am very new to VBA and I came accross this question for which I couldn't find an answer even after browsing the internet for hours. So, any help from experts like you all is highly appreciated.
I have two data sheets as Service Registry and Inhouse Inventory. There is a userform (ServiceDetailsUserForm) to feed data into Service Registry work sheet. All the materials in the inhouse inventory sheet are listed down in the MaterialComboBox in the ServiceDetailsUserForm. User have to select a material from the combo box and enter the quantity of material used for the service. After clicking the submit button on the user form, the material and the quantity used for the service should be entered to the Service registry work sheet and at the same time Inhouse inventry work sheet should be updated by subtracting the quantity of material used for the service from the quantity of the material which was available in the inventory.
Unfortunately I couldn't come up with a code which can even do half of the job, so I don't have a code to upload. Very sorry for that. Instead I will upload some pictures.
Thanks a lot in advance.
I am very new to VBA and I came accross this question for which I couldn't find an answer even after browsing the internet for hours. So, any help from experts like you all is highly appreciated.
I have two data sheets as Service Registry and Inhouse Inventory. There is a userform (ServiceDetailsUserForm) to feed data into Service Registry work sheet. All the materials in the inhouse inventory sheet are listed down in the MaterialComboBox in the ServiceDetailsUserForm. User have to select a material from the combo box and enter the quantity of material used for the service. After clicking the submit button on the user form, the material and the quantity used for the service should be entered to the Service registry work sheet and at the same time Inhouse inventry work sheet should be updated by subtracting the quantity of material used for the service from the quantity of the material which was available in the inventory.
Unfortunately I couldn't come up with a code which can even do half of the job, so I don't have a code to upload. Very sorry for that. Instead I will upload some pictures.
Thanks a lot in advance.