VB Code Help.....

[Mangler]

Need some help here with VB code... I have a sheet named Adjust
Inventory and one named Supplies Inventory.

The Adjust Inventory has a form with two fields and a subtract
button.... one is a part ( Cell C6) and the other is quantity (Cell
E6) .

When the fields are filled out and the subtract button is clicked, it
will take the value in C6 and search column D in the Supplies
Inventory sheet for that part.

Once the part is found, it will take the value in E6 on Adjust
Inventory sheet and subtract that from the value in the supplies
inventory sheet in column E for the found part.

Finally,after the adjustment has been made, the values filled in on
the Adjust Inventory sheet will get cleared out so the next request
can be done.


Can someone at least help me get started at least? I can manipulate
the code but am having trouble starting it from scratch.

 

[Shane Devenshire]

Hi,

The best way to start is to record your steps and look at the results and
see if and where you will need to modify the code. Likewise, you would get
better help here is you post the code you record and indicate what it is
trying to do and what in fact it is doing.

To start the recorder choose Tools, Macro, Record New Macro...