VBA worksheet change to scroll down to specific text

emacjake

New Member
Joined
Nov 4, 2014
Messages
29
Hi All

I'm reasonalby fluent in excel but my vba knowledge is limited.

I'm looking for some help with a code to scroll down to a specific title when a selection is made from a drop down list at the top of the page?

looking to save a lot of scrolling and ctrl F time

please help

Cheers!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
We need details.
1. What cell is the drop down list in?
2. And if you choose Sue from the drop down list where is Sue
 
Upvote 0
so in cell L4 is the drop down list with name of the outlet

and in Column B is the list, with the outlet name followed by list of all products sold in that outlet then the next outlet name and all prodcuts sold and so on, with 12 outlets this list is more than 2000 rows long

Thanks!
 
Upvote 0
Try this:

To install this code:

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste this code in the VBA edit window

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("L4")) Is Nothing Then
        If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
    With Range("B:B")
        .Find(Cells(4, 12).Value, LookIn:=xlValues, lookat:=xlWhole).Select
    End With
    End If
End Sub
 
Upvote 0
Thanks again

I'm looking to get a little more well rounded in the VBA language, is there anyting online you could suggest to learn some more of the basics, so far it's just been youtube and this forum,

I've learned some very helpfull macro's, and have a basic understanding on how to record and edit simple ones. but would like to know a little more about how they work and how to write them

Cheers
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

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