Hi,
I am trying to create a VBA script for a shop. The shop needs to check the stock of a product in a warehouse which is linked to the database.
I have a Sheet named 'Warehouse' where there will be a list of items that are in stock. I need the VBA script to have a combo box where the user can select the item to look for and then when the OK button is pressed, it displays the result whether the product is in stock or not and if so how many are there (Displayed in the B column of the Warehouse database).
Ideally after that, on the box displaying the result of the first test a Cancel Button to go back to the homescreen or a Order button which could be linked to another Form which then needs the user to be able to select the item, how many they want and then this should update the number in column C of the database by the number the user enters.
Any help with this would be greatly appriciated.
Thanks,
Tim
I am trying to create a VBA script for a shop. The shop needs to check the stock of a product in a warehouse which is linked to the database.
I have a Sheet named 'Warehouse' where there will be a list of items that are in stock. I need the VBA script to have a combo box where the user can select the item to look for and then when the OK button is pressed, it displays the result whether the product is in stock or not and if so how many are there (Displayed in the B column of the Warehouse database).
Ideally after that, on the box displaying the result of the first test a Cancel Button to go back to the homescreen or a Order button which could be linked to another Form which then needs the user to be able to select the item, how many they want and then this should update the number in column C of the database by the number the user enters.
Any help with this would be greatly appriciated.
Thanks,
Tim