Selection VBA Help

Yes, possible.

Make your code hide all the circle shapes on the map worksheet before showing only the required circle shape.

Or only have one circle shape, and set it's position based on the zip code selected.

Several ways to do it - hard to advise specifically without seeing how your existing workbook currently does things.

As I said - there are many approaches which MAY be taken, but to properly advise you on a solution which will fir your workbook, we'd really need to see your workbook...

Try attaching an example file.

Okay. See my attachment, for an example of how it can work.

Double click a zip code in column B of worksheet [Data], and the circle will move to the specified area of the map.

I've included a button on the map, for you to map additional zip code. Just manually move the circle to the location you want, click the button, and enter your zip code. The coordinates for that zip code will then be stored in the [coords] worksheet.

The code should be fairly straightforward to follow - when a zip code is double clicked, we look for a matching value in the [coords] list, which stores top and left positions for the circles, for each zip code. Those properties are then applied to the circle to change it's position, and the map sheet activated.

I'd value your feedback...