Can not get cell in Excel to update automatically

[structural01]

Hi,
I am fairly new to VB.

I could not get the cell "c11" in Excel to update automatically once a number is entered in cell "c10".

I wrote the following in VB ...
if c10<=10 then
x=1.0
range"c11".value=x
end if

if c10>10 then
x=2.5
range"c11".value=x
end if


Thanks in advance for any help.

 

[johnwm]

You need to reference the cell as a range each time.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("c10").Value <= 10 Then
x = 1
Else
x = 2.5
End If
Range("c11") = x
End Sub

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[structural01]

Johnwm,
Thanks for your respond.

I wrote this statement...

Range("E285").Value = 1.1766 - 1.1766 * Log(d285)

But, I am getting a error. It does not recognize cell d285. Am I doing something wrong?

Thanks again.

 

[johnwm]

As I said, you need to reference the cell as a range each and every time.

Range("E285").Value = 1.1766 - 1.1766 * Log(RANGE("d285").Value)

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[structural01]

I am not a computer person. So, the computer terminolgy is not understood.

Now I understand. I tried it and it works. Thanks for your help.