Only whole numbers between 1 and 100 can be entered.

Asked By anonymous 7060 points N/A Posted on - 08/22/2011

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?

• Status: Open
• Question Views: 1953
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Trevor

Go To Solution

Best Answer

Best Answer

Answered By Trevor 0 points N/A #80046

Only whole numbers between 1 and 100 can be entered.

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.

About Trevor

Questions
2

Answers
315

Best Answers
83

• Vote Up 0 Vote Down

• Posted on - 08/22/2011
• Question Category: MS Excel

Answered By kimanif 0 points N/A #80047

Only whole numbers between 1 and 100 can be entered.

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

About kimanif

Questions
0

Answers
50

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 09/12/2011
• Question Category: MS Excel