Only whole numbers between 1 and 100 can be entered.

Asked By 7060 points N/A Posted on -
qa-featured

You would like to restrict the values that can be entered into a cell so that only whole number between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?

SHARE
Best Answer by Trevor
Best Answer
Best Answer
Answered By 0 points N/A #80046

Only whole numbers between 1 and 100 can be entered.

qa-featured

You can only do this kind of condition inside the VBA macro. What you need is to create a macro that prompts for the input. Then assign the macro to a key like F5 or any key you want. Then make an instruction that on that particular column, the operator must press F5 to input values.

If the input value is greater than 100 and less than 1 prompt the operator that the value input is not valid and try again.

There are many other ways to solve this issue. It is up to you how you manipulate your code on the VBA macro.

Answered By 0 points N/A #80047

Only whole numbers between 1 and 100 can be entered.

qa-featured

Restricting the values to be entered in specific rows or column is possible in MS Excel and its called Data Validation. You can validate data by any value, whole number, decimal list etc.

This is the procedure:

Select one or more cells to validate. On the data tab, data tools group, click data validation.

Click the settings tab

·         In the Allow box, select Whole Number.

·         In the Data box, select the type of restriction that you want. For example, to set upper and lower limits, select between.

·         Enter the minimum, maximum, or specific value to allow. You can also enter a formula that returns a number value

Click ok. And you are done

Regards

Kimani F

Login/Register to Answer

Related Questions