List Box and Bookmarks

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
128
Office Version
  1. 365
Platform
  1. Windows
Is it possible to create a list box that when an item is selected will take you to a place on that sheet and how?

Thank you!
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
How did you load the data in the listbox?
Are you using any filter or criteria to load the data in the listbox?
 
Upvote 0
Hi Dante

I created a table with hyperlinks to the cell on the page in the workbook.

No filter or criteria

Thank you
 
Upvote 0
I'm not understanding.
Is the listbox in a userform?
You can put the detail of what you have.
 
Upvote 0
Upvote 0
No, I am lost.
At the beginning you mentioned a listbox.
You already created the listbox or what do you mean?

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 
Upvote 0
I am confused by the terms you use.
You don't have a listbox in your book, nor do you have data validation.
What you have is a hyperlik from the "LookUp Tables" sheet to the "2019" sheet.
If you already have the hyperlink, then what do you need?
 
Upvote 0
I am confused by the terms you use.
You don't have a listbox in your book, nor do you have data validation.
What you have is a hyperlik from the "LookUp Tables" sheet to the "2019" sheet.
If you already have the hyperlink, then what do you need?

There is a list box in Sheet 2019 A2, I thought adding the hyperlink in the table will take me there but it doesn't work. Trying to find a fix where the user can select a date from the list box and go that section of the 2019 worksheet. From my research looks like I may have to use hyperlink function but having issues with that too
 
Upvote 0
Sorry, I didn't see that you had a Drop-down list from a Data Validation.


Put the following code in the events of your sheet.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Count > 1 Then Exit Sub
  If Target.Value = "" Then Exit Sub
  If Target.Address(0, 0) = "A2" Then
    Dim f As Range
    Set f = Range("A4:D" & Rows.Count).Find(Target.Value, , xlValues, xlWhole)
    If Not f Is Nothing Then
      f.Select
    End If
  End If
End Sub

------------------------------------
HOW TO INSTALL Event Code

If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,329
Members
448,564
Latest member
ED38

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
Back
Top