I'm really new at this VBA code thing and have found almost everything
I need here from this group just don't understand some of the complex
things: Let me explain my problem
I have a userform built in VBA that has the following
cboline: combo box that list out production lines
cbomen: combo box that is the number of men on the production line
txtmin: The number of minutes the line was down
txtwait: a value that represent time the line waited on a part
txtmcost: the cost of the material
txtvcost: the cost for a outside vendor
txtcost: total cost of downtime
My big issue is each (cboline)&(cbomen) has a constant value:
example
line 1 = $100
line 2 = $150
line 3 = $200
line1 workers value (cbomen) = $12
line2 workers value (cbomen) = $13.25
I'm trying to find the total cost based on downtime for each line
example of my issue:
Line 1 (cboline) is down for (txtmin) 120 minutes but minus the
(txtwait) 15 minutes because of waiting on parts then take that value
and add the cost of (cbomen) each man working on the line and also add
the material cost (txtmcost) and vendor cost (txtvcost) for a total
cost (txtcost) of the downtime. I've been working on this for days
using this forum but no luck and I'm nearing the deadline for this
project. I would have down all these formulas in a worksheet but
this needs to behind the userform because it gives values of the men
working and it not something that should be viewed by the people using
the form. Thanks in advance
Chuck