[Q2] = "GO:MarketID"

[SenseiCRO]

Hello,

I'm trying to access the exact market with the ID.
For that I use the following code that is logical to me, but it doesn't work:

If Not Worksheets("Test").Cells(1, 1).Value = 105518871 Then
[Q2] = "GO:105518871"
Worksheets("Test").Cells(1, 1).Value = 105518871
End If

It puts the GO:105518871 the Q2 cell, but BA doesn't go to that market at all, and my Excel goes into the infinite loop. I use IF to stop placing the Q2 request more than once, but... it stucks.

What am I doing wrong?

[GaryRussell]

Is this code in the Worksheet_Change event? Each time you write to a cell it fires this event so [Q2] = "GO:105518871" causes the event to fire again before the next statement. It is good practice to disable events when writing to cells. Try changing your code as follows.

Code: Select all

If Not Worksheets("Test").Cells(1, 1).Value = 105518871 Then
   Application.EnableEvents = False
   [Q2] = "GO:105518871"
   Worksheets("Test").Cells(1, 1).Value = 105518871
   Application.EnableEvents = True
End If


[SenseiCRO]

Great, it works now, your suggestion has helped.
thank you for the excellent software and support.

cheers, dean