Simulate a mouse click within a cell (SOLVED)

[phantom1975]

I have a macro that will activate a particular cell. I now need to have that cell "clicked". Here's the cell's contents:

=hyperlink("http://www.mrexcel.com")

The only way to have the hyperlink work is to CLICK on it. No sendkeys seem to work.

NOTE: I know I have a similar thread on hyperlinks, but this one is specifically on how to simulate a CLICK and not so much the hyperlink function.

_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-11-06 20:46
This message was edited by phantom1975 on 2002-11-07 19:51

 

[Mark O'Brien]

Jaysus Christos!!! Do you never use the "Search" facility?

(just kidding )

Here's a link to a post I made:

http://216.92.17.166/board/viewtopic.php?topic=3028&forum=2

This simulates a right mouse click, but I included all of the constants necessary for any mouse click. Just substitute "RIGHT" for "LEFT" in the subroutine called "RightClick". (you may want to reanme the sub to "LeftClick for clarity and sanity)

If you need help with mouse move, just repost, I can do that as well.

 

[Mark O'Brien]

Dagnammit! You did warn us, but I see someone else solved you problem in the other thread:

http://216.92.17.166/board/viewforum.php?forum=2&121986

Put my solution down as "something useful, but not right now".

 

[Juan Pablo González]

Mark, this second link where is supposed to point to ?

BTW, another solution could be something like using ActiveWorkbook.FollowHyperlink

 

[NateO]

Mark, this second link where is supposed to point to ?

I believe Mr. O'Brien's broken link was intended to lead us to:

http://www.mrexcel.com/board/viewtopic.php?topic=28279&forum=2

Pretty ambiguous stuff!

Yes, while potentially interesting, it seems that it would be pretty rare and a huge amount of coding to simulate a mouse movement/click based on a target cell.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-06 23:59