Something like his should work...

With WorksheetFunction
Answer = 24 * (.Max(Textbox21.Value, TextBox31.Value, Textbox41.Value) _
- .Min(Textbox22.Value, TextBox32.Value, Textbox42.Value))
End With


--
Rick (MVP - Excel)


"ordnance1" wrote in message
...
I need something that will find the Max value found in Textbox21,
TextBox31, Textbox41 then multiply that number by 24 then subtracted the
Min value of Textbox22, TextBox32, Textbox42 multiplied by 24.

Ant textbox that is blank should be ignored.