Data Validation

[JIBG]

I have data entry form that the first input should be a unit number consisting of 6 numbers in a text box,. This input puts the 6 numbers in a dataTable in a sheet (Ex, sheet 1 cell A1). How can validate this input, in VBA ?
I formatted the cell in the target sheet, but I need to validate in the input from. I want to make the user to stop by popping a msgbox alerting that he/she needs to input 6 number not 1,2 3 4, 5 ,7 etc, or any other data type (or even better disable all the other input objects to be disable if the user doesn’t input the 6 integers).

[BigBas]

You dont necessarily need VBA. You can apply a data validation to a cell (or column) that only allows a 6 digit number to be entered.

Choose the cell upon which you would like to apply the data validation.
Go to DATA- Validation
From the allow dropdown, choose CUSTOM
Enter this formula: =AND(LEN(A1)=6,ISNUMBER(A1)=TRUE) *NOTE: This assumes that you are applying the validation to cell a1. Change the range to suit.
Next, you can use the other tabs in the validation dialog box to nter custom error messages, and other options.

Report back if this helps