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
How to delete a cell in word - Guide
Excel online macro - Guide
Macro for number to words in excel - Guide
How to run a macro in excel - Guide
Conditional formatting if cell contains text ✓ - 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

Clear cell contents based on value of another cell range using VBA

Automatically update a cell with last modified date and time

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

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!