We have a map of all rooms in our building. The map is a collection of drawn objects grouped together. The project is to allow the user to click a combo box in Excel, pick the desired room number, and have the appropriate room turn to a specified color on the map. I've used VBA to do a similar project before with Excel and PowerPoint. The difference is this time is we have hundreds of objects (the different rooms) versus a dozen or so for the past project.


My question is this:
Should I use PowerPoint or Visio? Is Visio more efficient or stable dealing with a large collection of objects? Are there other things to consider when using PowerPoint versus Visio? Thanks