+ Reply to Thread
Results 1 to 4 of 4

Data Validation or Combo Drop Box Worksheet Navigation

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Modesto, CA
    MS-Off Ver
    Excel 2007
    Posts
    45

    Data Validation or Combo Drop Box Worksheet Navigation

    Ciao All ~

    Not sure which forum to drop this question into, but here goes ...

    I'd like the end user to select from 100 different locations. When a selection is made the sheet will "shift" to the appropriate row on the worksheet.

    Is it possible to use Data Validation to navigate a list of cells in one column?

    Is a Combo Drop Box a better solution? This would require VBA, no?

    Appreciate the guidance.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Data Validation or Combo Drop Box Worksheet Navigation

    Hi art,

    Data validation is much easier than creating a Combo Box. If you want your cursor to jump to the correct section you could use an Event Macro of "After Update". You could change the value in a data validation cell and the code behind the sheet could then use this new value to jump. It sounds like you need VBA in either case. I'd use data validation with an Event Macro behind the sheet.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Modesto, CA
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Data Validation or Combo Drop Box Worksheet Navigation

    Do you have any examples of such an Event Macro? Or point me to good tutorial. I'm new to VBA ...

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Data Validation or Combo Drop Box Worksheet Navigation

    OK,

    Here is an example of what I meant.

    This is the fundamental idea. You could improve on this by named ranges in your sheet and VBA code...

    This example ties together Data Validation List, Event Macro of On_Change and Selecting a Cell location.

    Hope this helps.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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