Hello all,
I need to limit the number of allowed characters (actually values) in an input field within an input box

The input box syntax looks as follows

InputBox("If Code is needed for the file name, then enter code and click 'OK', else click 'Cancel'", "Optional Input", Environ("Code"))

Input Box1.JPG

User can optionally enter an 8 digit number in the format "12345678", but should not be able to enter >8 characters, but they can also simply skip that step (this is already working via the "Cancel" button)

Thanks in advance for your help :-)

Cheers,
Claus