I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???