If function using VBA

[Antik888]

Hey guys!
I need to make an input box with the following if function:
If the input value is less than or equal to the value of the cell situated 3 cells to the right from the active cell, than make the value of active cell equal to the quantity that the user has input, otherwise, the window popup has to say "Not enough quantity" and show the amount available (which is again 3 cells to the right from the active cell), and after the user presses ok, go back to the input box to repeat the procedure.
It is used for stock check-out.

Please Login or Register  to view this content.

Thank you in advance.
Anton.

[JieJenn]

in VBA, IIF is the replacement of IF. Or you can sue SELECT CASE statement.

[mojo249]

Please Login or Register  to view this content.

[abousetta]

And here's the shorter version:

Please Login or Register  to view this content.

abousetta

[rylo]

Hi

Making it loop until the criteria is met.

Please Login or Register  to view this content.

rylo

[Antik888]

Hi

Making it loop until the criteria is met.

Please Login or Register  to view this content.

rylo

Worked out perfectly! Thanks mate!