Dropdown Menu That Jumps To Corresponding Row After Selection

[IH8XEL]

Ok, I just discovered VBA in Excel so take it easy on me guys.

I'm trying to create a dropdown menu that is full of dates. I know how to create the menu and use data validation and all that. I would like to know how to enable a scroll function however instead of having to click on the direction arrows so if you could tell me how to do that I'd appreciate it.

My real question though is how to make the worksheet automatically scroll to a specific row that will correspond with the selection of a date in the dropdown menu.

Can someone point me to a tutorial for that specific code?

 

[IH8XEL]

So once you click on the box and the list drops down I want people to be able to use the wheel on their mouse to scroll through the options instead of having to click on the arrows to navigate through the list. Does that make more sense?

 

[MixedUpExcel]

Hi,

That does make sense.. unfortunately, that's not one of the 'things' I've got associated with my drop down box.

The only thing I can suggest here is that if the user knows what they are looking for, you might be able to use one of the options under 'properties' for the Combo Box.

Match Entry (within Properties) has some options where you can allow the user to type the first letter and then it narrows the search down so they don't have as much to scroll through?

Other than that, I don't know how to control the menu with a mouse scroll wheel but I'm sure there will be a way.. I've just never needed that.

Good luck with finding that solution though.

Thanks.

Simon