Hi everyone, I am pretty new to vba but I have been coding for a long time in c/c++. What I want to do is :
When I write on a selected cell for example INTC I want the cell right next to it to display sometihng like FIBBONACCI('INTC') <= 50
So what I did is : use Worksheet with change and this is the code :
But the result keeps cascadiing :Private Sub Worksheet_Change(ByVal Target As Range) Dim SymbolName As String SymbolName = Target.Value ActiveCell.Offset(-1, 1) = "FIBBONACCI(" & SymbolName & " ) <= 50" End Sub
FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACC I(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONA CCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBO NACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIB BONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(F IBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI (FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(FIBBONACCI(intc ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50 ) <= 50
What is wrong in my code? Thank you very much