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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
17,913
Office Version
  1. 2013
Platform
  1. Windows
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
 

emacjake

New Member
Joined
Nov 4, 2014
Messages
29
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!
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
17,913
Office Version
  1. 2013
Platform
  1. Windows
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
 

emacjake

New Member
Joined
Nov 4, 2014
Messages
29

ADVERTISEMENT




You are a LORD!

Works perfect!

Thanks so much for you help!
 

emacjake

New Member
Joined
Nov 4, 2014
Messages
29
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
 

Forum statistics

Threads
1,143,654
Messages
5,720,090
Members
422,266
Latest member
Mattyw

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
Top