G
gary87
For a school project I am working on I have a database of stock levels
The database is basically a table on a Stocks Worksheet. Each row is
different product and the various columns afterwards contain the stoc
levels for each size.
On an Order Worksheet, I have a userform which the user types in thei
product and how many they require. When they hit OK, the sheet display
their stock, the current stock and what the stock will be (i.e it take
the order value away from the current value.) If everything is OK, th
user can click on a button which verifies the order. I need a macro o
simple VBA script that will take the new stock levels, search throug
the database and find the row which has the same product code an
update the stock levels. Any ideas.
Also, is it possible to validate the information entered into TextBoxe
on userforms?
Thanks in advance
The database is basically a table on a Stocks Worksheet. Each row is
different product and the various columns afterwards contain the stoc
levels for each size.
On an Order Worksheet, I have a userform which the user types in thei
product and how many they require. When they hit OK, the sheet display
their stock, the current stock and what the stock will be (i.e it take
the order value away from the current value.) If everything is OK, th
user can click on a button which verifies the order. I need a macro o
simple VBA script that will take the new stock levels, search throug
the database and find the row which has the same product code an
update the stock levels. Any ideas.
Also, is it possible to validate the information entered into TextBoxe
on userforms?
Thanks in advance