Userform inputs comparison with sheet cells and if true reset userform fields

Hi all,

I have a spread sheet where Sheet1 contains 5 header columns; PO, PO Line, Total Hours, Hours Booked and Remaining Hours. The data for the first 3 is entered manually, the Hours Booked comes from a Userform1 inputs and Hours Remaining is a simple calc.

The Userform1 selects PO and PO Line via comboboxes (linked to Sheet1) and inputs Hours Booked via textbox and appends these details to Sheet1, therefore updating the calculations for Hours Remaining.

When entering the data on Userform1, I'd like it to reset or blank the PO and PO Line fields (plus throw a warning message on screen) if the Hours Remaining on Sheet1 minus the Hours Booked on the Userform1 for that PO and PO Line would result in a value less than zero. I.e. it won't submit the data.

Hope that makes sense.

Ok sanitised workbook attached.

The Menu tab has the userform with the inputs which are written to the Data tab. The Part4 tab then interrogates the data tab and will prevent further bookings to PO / PO Lines if it would cause Part 4 Column E to go negative, so I'd like to reset or blank the userform PO number and PO line number fields hence preventing overbooking of those and show a message as such.

Thanks

Ok I could save in 2003 and post here?

Ok thanks anyway, is anyone else able to help with this please?

Try

Please Login or Register  to view this content.

Kind regards
Leo

few modifications marked in red

Please Login or Register  to view this content.

Kind regards
Leo

That's great thankyou!!

no thanks,

if you have no more questions, please mark the case as solved

Kind regards
Leo