Creating VBA Form To LookUp Stock

[timpickup]

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

 

[dmt32]

Hi welcome to the Forum.

Have a look here:http://www.contextures.com/excelfiles.html#UserForm

and then look down the file list for:

UF0020 - Parts Database With Dependent Combo Boxes

or

UF0017 - Parts Database with Updateable Comboboxes

These are two files you can download for free & although are not all you want could be used as a basis maybe to build your project.

The site also has helpful section giving guidance on creating userforms which you also may find helpful:

http://www.contextures.com/xlUserForm01.html

Hope Helpful

Dave