Excel macro.Pls help

[bkyeong]

can i fix a cell (B4) so that it could only receive numeric number and the length is 8. how to do it in excel macro? pls help.

 

[Anne Troy]

You don't need a macro. Go to the Data menu and choose Validation. Check out all of the options there.

 

[Todd_M]

Range("b4").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _
Operator:=xlLess, Formula1:="99999999"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = Warning
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

Try this, it should work

goodluck- Todd