Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,422
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Selecting item in Drop down

    I would like to be able to select an item in the drop down-se attached and go to the cell number where the cell is in Col A for eg if I select BRZZ1, I must then go to A4

    See sample data attached

    Your assistance in resolving this is most appreciated
    Attached Files Attached Files

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Copy this to the sheet module and save your workbook as .xlsM or .xlsB
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> Range("a1").Address Then Exit Sub
    Columns(1).Find(What:=Target, After:=Cells(1, 1), LookIn:=xlValues, _
               LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
               MatchCase:=False, SearchFormat:=False).Activate
    End Sub
    Last edited by RetiredGeek; 2015-03-18 at 13:37. Reason: Added Code Tags
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,422
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Thanks for the help Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •