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
Based on the cell values in cells b77 - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
Count if cell contains number - Excel 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

If cell A1 has text then cell B2 has today's Date

Automatically Run Macro from a calculated cell value change

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!