ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I tell what cell I was in last? (https://www.excelbanter.com/excel-programming/394415-can-i-tell-what-cell-i-last.html)

Graham Y

Can I tell what cell I was in last?
 
I now have my hyperlinks working (many thanks to Vergel Adriano), but I'd
really like to know if I landed on the current cell as a result of clicking a
hyperlink or just clicking on the cell.
When my user goes to a cell a form opens up, for data entry, if the user
accepts the values and they arrived there by using a hypelink, I want to
delete the hypelink. I am reluctant just to delete the hyperlink once clicked
in case there is a query with the values linked to. But if I could tell where
I had come from, I could add code to my OK button, to delete the hyperlink.

Hope that makes sense!


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com