How can I use a dropdown box to go to various cells in my spreedsheet?

**melverz** · 07-15-2009, 04:33 PM

What I would like is to use a dropdown box with a list of team names, when you click on a team it will go to that cell where the team is located. If that's not possible can I put a number in a cell and enter and that takes me to the location of the cell with the team name in it?

**JBeaucaire** · 07-15-2009, 04:48 PM

If the team names are in column B and the cell with the dropbox is A1, then right-click on the sheettab and select VIEW CODE, then paste in this sheet macro:

Please Login or Register  to view this content.

Then press Alt-Q to exit the editor and save your sheet.

Now anytime you make a choice in A1, it will search column B for the match and jump to that cell.

**melverz** · 07-16-2009, 04:03 AM

Thanks it works if I manually input a number or team in the cell but doesn't seem to work when I use the drop box. I'm not too bothered as the dropbox was more for cosmetic reasons. The main thing was to to get to a particular cell in the spreadsheet which this does. Thanks again

**JBeaucaire** · 07-16-2009, 08:01 AM

If you use a DataValidation drop box it SHOULD work. I've used ws_change events with dropbox triggers before.

Anyway, if that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)