Excel macro.Pls help

bkyeong · Apr 11th, 2002, 06:09 PM

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 · Apr 11th, 2002, 06:48 PM

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

Todd_M · Apr 11th, 2002, 07:03 PM

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

Apr 11th, 2002, 06:48 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You don't need a macro. Go to the Data menu and choose Validation. Check out all of the options there. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 06:09 PM	#1
bkyeong New Member Join Date: Apr 2002 Posts: 24	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.

Apr 11th, 2002, 07:03 PM	#3
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	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