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
Excel online macro - Guide
Numeric to word in excel - Guide
Numeric keypad mac - Guide
Excel run macro on open - Guide
Automatically run macro in excel when cell changes - Guide

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 cell A1 has text then cell B2 has today's Date

Automatically update a cell with last modified date and time

If a cell contains any text then add a value

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!