I have a spreadsheet that is very large. data everywhere.
how do i create a macro for a combo box so when i

1) type a shortcut key it opens up the combo box where
ever i am on the spreadsheet

2) the combo box contains a list of items so when i
select an item it takes me to an assigned cell
destination.

this will help me navigate my spreadsheet a lot quicker
then having to scroll all over the place to look for
certain data.

thank you