+ Reply to Thread
Results 1 to 3 of 3

Drop down menu with reference to cell

  1. #1
    Registered User
    Join Date
    09-07-2019
    Location
    Paris
    MS-Off Ver
    2016
    Posts
    2

    Drop down menu with reference to cell

    Good morning/evening !


    I would like to create a menu presented as a drop down list so that when I click on any of the choices, it refers to a cell in the same excel sheet. The original sheet I am working with is rather big with about 1000 lines (I cannot break it into smaller sheets because I need all the information inside that one sheet). There are titles for different sections so the menu is really to facilitate the navigation through the sheet. For example, there are 3 sections and I want to go to section 2, I click on the menu, select section 2 and it takes me to the title where section 2 is.

    I have attached a sample of what my big file looks like.

    Hopefully you can help me. I am not very good (if not at all) with vba so any help is very much welcomed.

    Thank you for your time !
    Attached Files Attached Files

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,405

    Re: Drop down menu with reference to cell

    Welcome to the forum!

    1. In C2, add a Data > Data Validation > List > Revenues,Operations,Capital
    2. Right click the sheet's tab, View Code, and paste.
    Please Login or Register  to view this content.
    3. Freeze row 3.
    4. Save file as xlsm type.
    5. Test C2 dropdown.

  3. #3
    Registered User
    Join Date
    09-07-2019
    Location
    Paris
    MS-Off Ver
    2016
    Posts
    2

    Re: Drop down menu with reference to cell

    Wow, it works ! Thank you, thank you !!

    Hope you have a great day !


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1