Only whole numbers between 1 and 100 can be entered.
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?
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?
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.
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