By Adam Nagy If you use the same Title Block definition for all Sheet's then you can go through its Definition, check for the Prompted Entry Text Box's and keep track of what each Text Box had as value in the main/master sheet where all these values are correct.
Now you can update all the other sheets with those values. Text Boxes Dim box As Text Box For Each box In boxes ' Check if it's a Prompted Entry If In Str(1, box.
Once amount is posted either as Receipt or Invoice should affect the Paid or balance text boxes.
Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.
Users enter inventory data by opening the User Form, filling in the boxes, and clicking a button.