Can not get cell in Excel to update automatically
Can not get cell in Excel to update automatically
(OP)
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.
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.





RE: Can not get cell in Excel to update automatically
CODE
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: www.essexsteam.co.uk
RE: Can not get cell in Excel to update automatically
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.
RE: Can not get cell in Excel to update automatically
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: www.essexsteam.co.uk
RE: Can not get cell in Excel to update automatically
Now I understand. I tried it and it works. Thanks for your help.