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
How to run a macro in excel - Guide
Run macro on opening: worksheet, workbook - Guide
Excel multiple lines in one cell - Guide
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - 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

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

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

Similar discussions

Subscribe To Our Newsletter!