Have you thought about naming specific ranges? Then you could navigate to
them using the Name Box (the dropdown to the left of the formula bar)
without dealing with floating Combo Boxes.

--

Vasant

"Ryan" wrote in message
...
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