Adding a MsgBox dependent on less than a cell?

Hello!

I currently have a Userform that allows users to change the quantity of a part that they are about to ship out.
I would like to change the code such that if the user changes the quantity to a number larger than what is on stock, a message box appears saying "Quantity too large. See On Stock Qty"
I have uploaded the example workbook in here, and the Userform code can be seen below.

Please Login or Register  to view this content.

You could replace your textbox_change event with

Please Login or Register  to view this content.

Hi Fluff13,

That worked, thank you! I just had to switch around the positioning (Pos, 6) instead of (Pos, 2) and also extend my listbox from A6:D11 to A6:G11

Thanks for the insight! I am rather new to creating userforms. Much appreciated

Glad to help & thanks for the feedback