Simulate a mouse click within a cell (SOLVED)

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
Jaysus Christos!!! Do you never use the "Search" facility?

(just kidding :biggrin: )

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. :)
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Mark, this second link where is supposed to point to ?

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

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
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! :biggrin:

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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,078
Messages
5,599,632
Members
414,326
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top