goseek macro does not run automatically

[Phil1934]

works when hit run but need it to be automatic when values are changed

[#2]

Hi @Phil1934 

There are many different triggers that can be used to automatically run a VBA. If you want it to run every time you make a change, you can use the change event. Go to VBA Editor, select the sheet you want this to work on, add a worksheet change event and add your code