List Box and Bookmarks

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
73
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!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
How did you load the data in the listbox?
Are you using any filter or criteria to load the data in the listbox?
 

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
73
Hi Dante

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

No filter or criteria

Thank you
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
I'm not understanding.
Is the listbox in a userform?
You can put the detail of what you have.
 

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
73
I'm not understanding.
Is the listbox in a userform?
You can put the detail of what you have.
I used data validation to link to this table and the each date is linked to a cell in another worksheet - does that help?:
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
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.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
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?
 

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
73
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
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,977
Messages
5,411,622
Members
403,383
Latest member
Excelacity

This Week's Hot Topics

Top