Need to declare a cell as numeric in macro

Solved/Closed

amit - Jul 6, 2010 at 06:01 AM
rizvisa1 Posts 4478 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.

Need to declare a cell as numeric in macro
Numeric to words in excel - Guide
Excel macro to create new sheet based on value in cells - Guide
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 6, 2010 at 07:01 PM

You have to put cell validation. See help on validation

Similar discussions

help me to add particular cells

If a cell contains any text then add a value

Formula to Find&replace blank cells in excel

Automatically Run Macro from a calculated cell value change

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!