Thanks for writing! How big are your containers? In your area, you'll need containers that are about 4 feet in diameter or more. If the pots are smaller than that, it's likely any perennials you'll grow will freeze and die over winter.
If your pots are the right size, then any Zone 4 hardy vine should work, including some types of grape, clematis, Canadian climbing roses, perennial sweet pea, Virginia creeper, and more. Check them out at: http://www.bhg.com/gardening/plant-dictionary/vine/
I hope this helps!
---Justin W. Hancock
Senior Garden Editor, BHG.com
Better Homes and Gardens