Excel Macro Won't Record the clicks

[zit1343]

Hi
I am trying to use macro to record clicks and repeat them
but it won't record the click, this is how it goes
I click Cell B1 than dialog box on right side will open automatically, in that box I have to click Apply or OK for it to generate data, I am doing that but it is not recording the click I made in that dialog box, is there a way I can use autocliker in excel VBA or something to record the click and autoclick it. or something like this

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



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

\1

[6StringJazzer]

The Excel macro recorder does not really record clicks. It records the internal state changes that result from user actions. This is a subtle difference. Some actions are not recorded.

For example if you click on Format, Format Cells, then select a bunch of options, the option settings are captured in the code, but not just the things you changed. If you make a centered, the code will have a whole list of cell format characteristics.

There are some things that can't be captured with the macro recorder, like inserting a rectangle shape onto a worksheet.

What is generating that dialog box? I am not familiar with it. If it is from an add-in then the macro recorder is probably not going to work.

There are tools that capture screen clicks and play them back, usually for the purposes of testing GUIs, but I've not used one so I don't have a recommendation. Here is an example just to show you what's out there, but I haven't used it and have no opinion on it.