You could use hyperlinks - these will take to to cells
anywhere in the workbook.
You could use a sheet event , like right click then move
the combo box by setting its top and left properties to
the cell that you're in....

Place the following code in the sheet's code page ---
hint: right click the sheet tab & select View Code

Private Sub ComboBox1_Click()
ComboBox1.Visible = False
' process combo
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As
Range, Cancel As Boolean)
Cancel = True
ComboBox1.Top = Target.Top
ComboBox1.Left = Target.Left
ComboBox1.Visible = True
End Sub

Patrick Molloy
Microsoft Excel MVP

-----Original 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
.