values

[Guest]

Hi
I want to set a cell as follows

if cell a1 >=3 then cell b1 must return x
but i want to restrict cell a1 to be less than 10 as well. in other words
cella1 must be greater or equal to 3 but less than 10.

PLEAAASE Help.

 

[Jörg]

Hi,

please insert the followin code intoo you Worksheet
------------------------------
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("A1").Value < 3 Or Range("A1").Value > 10 Then
MsgBox "only between 0 an 10"
Range("A1").Select
End If
End Sub

 

[Guest]

Look at Data=>Validation.

If you select Whole Number or Decimal, you are offered a Between Option
where you can set the min and max values.