Automate Double-Click

[Seth]

Does anyone know if it is possible to write a macro to
automatically perform a "double-click" operation on the
mouse. I would like to setup a task to repeatedly use
the double-click on the mouse while AFK at a timed
interval...just need to know if this is possible.

Thanks!

 

[Frank Kabel]

Hi
not quite sure what you're trying to achieve but maybe using the OnTime
method would be a better approach (than to simulationg doubleclicks).
Have a look at
http://www.cpearson.com/excel/ontime.htm
for more information about OnTime

 

[Tom Ogilvy]

You would have better luck executing the result of the double click than to
try to perform a double click as long as your focus is in Excel itself. So
if the double click fired an event, you could trigger the code run by the
double click using application.ontime.

Frank has given you a link to Chip Pearson's page on using
application.ontime.

 

[Tushar Mehta]

What does AFK mean?

Why not directly call the code that would be run as a result of the
double-click operation?

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office