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!

You are welcome. Thanks for the feedback.

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.

List Box and Bookmarks

E

Solved

Check Box and Text

Replies: 8

Views: 134

Apr 2, 2024

rpaulson

J

Question

Consolidate data from multiple sheets based on values selected in dependent list boxes

Replies: 0

Views: 214

Feb 16, 2024

jconda

J

S

Solved

excel list box

Replies: 4

Views: 192

Feb 10, 2024

Peter_SSs

D

Question

Create Dependent Check Box Selection

Replies: 2

Views: 70

Apr 16, 2024

Dokat

D

A

Question

VBA Userform List Box to Populate upon entering a specific text in Column B, copy data upon selection and paste data in the same Row in another Column

Replies: 3

Views: 184

Mar 12, 2024

arijitirf

A

List Box and Bookmarks

tbrynard01

Board Regular

tbrynard01

Board Regular

Excel Facts

DanteAmor

Well-known Member

Similar threads

Forum statistics

Share this page

List Box and Bookmarks

tbrynard01

Board Regular

tbrynard01

Board Regular

Excel Facts

DanteAmor

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock