Need to declare a cell as numeric in macro

Solved/Closed
amit - Jul 6, 2010 at 06:01 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 6, 2010 at 07:01 PM
Hello,


i need to declare a cell in excel as numeric so that only numbers can be entered in that cell and if any other text is entered then it displays a msgbox.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 6, 2010 at 07:01 PM
You have to put cell validation. See help on validation
0