Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert Data when hyperlink is clicked
I have a set of reciept numbers on one worksheet and i want you to be able to click on the reciept number and it will put that reciept number in cell J1 on the other worksheet. Is there a way to do this? -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=465742 |
#2
|
|||
|
|||
You could do it using the FollowHyperlink event of the worksheet which is
available, if I remember correctly, in Excel XP and above. -- Regards, Juan Pablo González Excel MVP "Chuck N" wrote in message ... I have a set of reciept numbers on one worksheet and i want you to be able to click on the reciept number and it will put that reciept number in cell J1 on the other worksheet. Is there a way to do this? -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=465742 |
#3
|
|||
|
|||
John Peltier definetly helped me out with this! Here is the code if anyone is interested Code: -------------------- Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) ThisWorkbook.Worksheets("Form").Range("J1").Value _ = Target.Range.Value End Sub -------------------- -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=465742 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert excel data source into word doc using currency symbols | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
insert data into chart | Charts and Charting in Excel | |||
Import Data: on insert, shift data down and not right | Excel Discussion (Misc queries) | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |