How can I declare the variable from the list for ADODB query ?

[MarieParis]

Test

[#2]

@MarieParis 

VBA uses straight quotes "...", not French quotes. So:

If Target.Address(False, False) = "E15" Then

[#3]

Hello,
Thank you !
I replaced, but it doesn’t work (

[#4]

@MarieParis 

Click in the line

Private Sub Worksheet_Change(ByVal Target As Range)

and press F9 to set a breakpoint.

Change cell E15 and press Enter.

The code will pause at the above line.

You can press F8 repeatedly to execute the code line by line.

Does that provide a clue?

[#5]

F8 doesn’t work at all (

[#6]

What does it mean The code will pause at the above line ?

[#7]

I would like just click on the variable in the list and after use this variable on my sql query.

[#8]

@MarieParis 

Could you attach a copy of the workbook (without sensitive information)?

[#9]

My code is

[#10]

@MarieParis 

We're not getting any further. Perhaps someone else can help you.