I am using a textboxes in a userform for ordering supplies. I want to check
to see if the quantity entered exceeds the max stock level. The userform is
executed while from Worksheet("Order"). The value for the max stock level
(for this particular medication, is on Worksheet("List") in cell Z3.

I had a macro that I thought would execute AFTERUPDATE. Apparently I am not
doing something right. Not sure if this matters, but the computers that will
be using this have touchscreens and the computer I am writing it on does not.

The user will first enter the ambulance number, then tab, enter, or touch
screen, to advance to the next textbox. Lets say the user enters a value of
5 for Textbox6. The macro should execute, afterupdate, to pull the max stock
level (4) and compare. If 54, then I will clear Textbox6 and setfocus to
textbox6 after displaying a msgbox about the invalid entry.

Any ideas on why it may not be executing, or show me what it should look
like. I am on a different computer to send this message then what my code is
on so I cannot copy and paste.

Thanks,
Les