Data Entry Restriction

[jayson26]

Is it possible to create a rule, function, formula, or VBA that would allow the user to ONLY enter specific values?

Example:

cell A1 is 6
in B1 I only want to allow entries of 6, 12, 18, 24, etc..

cell A2 is 4
in B2 I only want to allow entries of 4, 8, 12, 16, 20, etc..

Thanks!!!

 

[gnaga]

Select the cell you want to restrict data entry then
click menu Data!Validation. In the "Allow" box choose "List" and in the "Source" box type the list of values like 3,6,9,12... Click Ok

GNaga

 

[Juan Pablo González]

Select cell B1, then select the entire column. Then, go to Data | Validation, and in "Custom" enter this formula

=MOD(B1, A1)=0

this will also allow B1 to be 0. If this can't happen, then use this one:

=(B1 > 0)*(MOD(B1, A1)=0)