How to Set the Maxlenght on a cell with Macro

[antoni]

Hello bos, How to Set the Maxlenght on a cell with Macro ?
i want set the maxlenght on cell A5 is 5 digits and only numeric.

thank's before..

[protonLeah]

Try the macro recorder. Select Settings, Allow: Whole number, Data between:
Minimum: 10000, Maximum:99999

[D_Rennie]

This can be done with data validation.

go data validation, whole number, less than or = to, 99999

hope this helps