List Box and Bookmarks

[tbrynard01]

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!

 

[DanteAmor]

How did you load the data in the listbox?
Are you using any filter or criteria to load the data in the listbox?

 

[tbrynard01]

Hi Dante

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

No filter or criteria

Thank you

 

[DanteAmor]

I'm not understanding.
Is the listbox in a userform?
You can put the detail of what you have.

 

[tbrynard01]

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?:
[TABLE="width: 128"]
<colgroup><col></colgroup><tbody>[TR]
[TD]IOP Dates[/TD]
[/TR]
[TR]
[TD]11/08/19 - 11/10/19[/TD]
[/TR]
[TR]
[TD]11/15/19 - 11/17/19[/TD]
[/TR]
[TR]
[TD]11/22/19 - 11/24/19[/TD]
[/TR]
[TR]
[TD]11/29/19 - 12/01/19[/TD]
[/TR]
[TR]
[TD]12/06/19 - 12/08/19[/TD]
[/TR]
[TR]
[TD]12/13/19 - 12/15/19[/TD]
[/TR]
[TR]
[TD]12/20/19 - 12/22/19[/TD]
[/TR]
[TR]
[TD]12/27/19 - 12/29/19[/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

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.

 

[tbrynard01]

https://www.dropbox.com/s/efx3n61say28h80/IOP.xlsx?dl=0

Hoping I did that right

 

[DanteAmor]

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]

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]

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.

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.