Create Shape/Button Hyperlink to Specific Cell Value In Excel

**bjnockle** · 01-09-2021, 12:16 PM

Looking for button hyperlink to go to a specific cell based on largest number in the cell. In the attached sample file, the hyperlink button is to look at the number in column A and when the button is clicked, it should go to the cell with the largest number in column A. For this sample file, the largest number is 8.

I have created a button in the sample file but is it is not working as intended. Also used the hyperlink function to create a link to the maximum value in column A but the drawback with this is that someone could mistakenly delete/remove the formula in the cell.

Not looking for a VBA code.

See attached file.

Thanks.

**Bo_Ry** · 01-09-2021, 12:24 PM

1. Create a range name Mx =A1
2. Edit/Create Hyperlink to Range name Mx
3. Edit range name Mx =INDEX($A:$A,MATCH(MAX($A:$A),$A:$A,))

**bjnockle** · 01-09-2021, 02:11 PM

Bo_Ry: I cannot recreate the solution with your steps. How do I create hyperlink to Range name Mx? Solution works like a charm but cannot recreate and get it to work in my file. Need step by step description.

Thanks

**bjnockle** · 01-10-2021, 02:59 PM

Bo_Ry: Working Bo_Ry - thanks for the solution

**Andy Pope** · 01-09-2021, 12:28 PM

How about using your formula that locates the cell in a named range.

I had to start by defining the named range as a simple cell reference. It as then available to select when using the edit hyperlink dialog.
Once the link was present I was able to replace the cell reference with your INDEX formula.

Obviously the user could still change the formula via Name manager but you would have to lock down the sheet to stop that anyway.

**bjnockle** · 01-09-2021, 02:12 PM

Andy: I cannot recreate the solution with your steps. How do I create hyperlink to Range name? Solution works like a charm but cannot recreate and get it to work in my file. Need step by step description.

Thanks

**Andy Pope** · 01-10-2021, 07:14 AM

both solution use the same approach.

Use Formula > Name manager.
Add a named range BIG_CELL, which references Sheet1!A1

Select the shape and insert a link. On the hyperlink dialog chose the Place in this workbook. You should see BIG_CELL within the Defined Name section.

Once you have the shape linked to the static cell go back to Name Manager and change the reference to be the result of you INDEX formula.

**bjnockle** · 01-10-2021, 12:58 PM

Andy Pope: Not able to see BIG_CELL within the Defined Name section. I am using Excel 2010, which may be why I am not able to see BIG_CELL within the Defined Name section.

Thanks.

**bjnockle** · 01-10-2021, 02:57 PM

Andy Pope: Working now! Thanks for the solution

Create Shape/Button Hyperlink to Specific Cell Value In Excel

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Re: Create Shape/Button Hyperlink to Specific Cell Value In Excel

Thread Information

Users Browsing this Thread

Similar Threads

Can I create a Hyperlink/Button that reads its cell reference from another cell?

create a button in excel with macros or VBA code in a specific cell targets.

[SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style

Excel VBA in a userform that create a hyperlink into a specific cell location

Create macro to generate hyperlink to a specific file from cell

Screentip / Hyperlink & Button/Shape

Hyperlink button to a specific cell in excel

Bookmarks

Bookmarks

Posting Permissions