PC Review


Reply
Thread Tools Rate Thread

Can I tell what cell I was in last?

 
 
=?Utf-8?B?R3JhaGFtIFk=?=
Guest
Posts: n/a
 
      30th Jul 2007
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options Yuvraj Microsoft Excel Misc 0 29th Jun 2009 11:20 AM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Programming 1 21st Aug 2008 10:13 PM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Worksheet Functions 0 21st Aug 2008 08:44 PM
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON CAPTGNVR Microsoft Excel Programming 2 8th Jul 2007 04:18 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D =?Utf-8?B?YWJtYjE2MQ==?= Microsoft Excel Misc 5 26th Jan 2006 06:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:08 AM.