How to activate VBA in the sheet without F5

[McM_]

Hello, please, a code that automatically activates the formulas in the sheet, without the need to activate Macros with F5. In Example 1 I took a simple formula just to see the code that automatically activates the formulas in the sheet.
In examples 2 and 3, I have codes that are automatically activated in the sheet when a condition is met.
Thank you!

Sub Formula()

    'I want this code to run without F5
    Range("C2:C8").Select
    ActiveCell.FormulaR1C1 = "=IF(RC[-2]>0,(RC[-2]+RC[-1]),"""")"
    Range("C2:C8").Select
    Range("C3").Activate
    
End Sub

Private Sub worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet

'activation without F5
If Target.Column = 8 Then
Range("I" & Target.Row) = Now
End If

If Target.Column = 14 Then
Range("M3:M" & Target.Row) = Range("L3")
End If

End Sub

 

[McM_]

I added the table

VBA.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Example 1							Example 2				Example 3
2	it only works with F5 activation							it works without activating F5				it works without activating F5		write here
3	1	2	3	it only works with F5 activation				abc	27.10.2023 10:14			test	test	yyt
4	3	4		didn't work				cda	27.10.2023 10:14				test	gghfh
5	5	9		didn't work				bac	27.10.2023 10:14				test	ghgh
6	4			didn't work				abd	27.10.2023 10:15				test	yuyu
7									28.10.2023 05:39
8
9
10
11
12
13
14
15
16
17
18
Foaie1

Cell Formulas
Range	Formula
C3,C16:C18	C3	=IF(A3>0,(A3+B3),"")

 

[Peter_SSs]

Duplicate to: VBA activate Sheet in Excel

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.