How do you make VBA code run automatically?

[Jyggalag]

Hi all,

I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why?

Thank you!

 

[bebo021999]

Hit F5 or hit play symbol (right under "Book1" in the image)
or assign into a button/shape in sheet

 

[Jyggalag]

Hit F5 or hit play symbol (right under "Book1" in the image)
or assign into a button/shape in sheet

okay thank you.

But this is the macro solution no?

Is there a way to make it run automatically, so A1 is always = the value of B1?

 

[Jyggalag]

okay thank you.

But this is the macro solution no?

Is there a way to make it run automatically, so A1 is always = the value of B1?

So for example if I change the current value "Assessment" to "TestABC" in cell B1, cell A1 will automatically immediately update its value to this as well.

 

[bebo021999]

Put in in sheet1_change even, to trigger change in cell B1 (with manual input in cell B1, not via formula)

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$1" Then Range("A1").Value = Range("B1").Value
End Sub

BTW, why not put formula in sheet, cell A1:
= B1
???