VBA Excel Autoclicker

[Legacy 185509]

Hi
This is my last choice I do not have other choice, so I hope this will work
is there way to do auto clicking in excel, I have one button VBA/Marco that will search for certain text and after finding that text it will automatically open a box on right side of excel and on that box I or user needs to click ok/apply for it to fetch/generate data, is there a way for auto clicking using X & Y coordinates on screen to click those button so I do not have to for over 200 cells to that is 400 click
please help me or suggest me better way to do it
thank you

 

[dave3009]

If this is an Excel dialogue box then you can choose to turn them off during the macro execution.

Application.DisplayAlerts = False

'.....Your code

Application.DisplayAlerts = True

 

[Legacy 185509]

see the problem is macro won't record on the dialogue box, I need it to do that, I need macro to record those clicks on the box, check out the picture I posted it explain what i am trying to show

image removed, sensitive information