Select Case code not executing macro on Dropdown (change)

Please see workbook. The module 'Navigation' has macros that simply go to a sheet when the drop down is changed to a certain word. The first subroutine is for the drop down on the 'Navigation' worksheet. I am trying to call the navigation macros when the drop down changes.

I think I have the code right... But maybe it's not in the right place or something? Can someone take a look and help out?

Thanks!
-Heather

Excel 2007 or 2010 workbook

Hi 4am

I've never used Dropdowns but apparently they use Index Numbers. Try modifying your code similar to this

Please Login or Register  to view this content.

See if it works.

John

I'm checking it out now. I guess I need to learn more about Index numbers.

Thank you John! Very helpful. It works just the way I wanted and is even easier to write the code. +Rep!