how to do a sum between sheets with tolerances using vba code?

[sspreyer]

hi, all

I wonder if any one can help me?

let start from the beginning I have 2 worksheets

sheet1 contains measurements for a part
sheet2 contain the specification for the part on sheet1

so I put the measuring result of a part on sheet1 then click a command button and opens a userform and I would like to cross reference's it to the measurements on sheet2 to check if within specification. Now if a out of specification condition happens I would like to show how much this is out of specification

e.g me.textbox1.value = ("sheets2")Range("b4") - ("sheets1") Range("c25")

on sheet 1 c25 cell value is 82.440 and sheet2 b4 value is 82.500 but i have lower tolerance of -0.050 ( tolerance is storage on sheet2 d4) but I only want the textbox to display the amount over the tolerance which would be = -0.010 also how can i round this up to only show 4 digits after decimal


very much appreciate any help

thanks in advance

[Richard Buttrey]

Hi,

An actual workbook with a before and after situation is worth a thousand words. Please upload.

[sspreyer]

hi

here is a stripped copy of the work book
tried labelling best I can

thanks

shane

Test file Forum.xlsm