You can visit Vancouver throughout the year, and there will always be something going on to interest you. June - October is the warmest time of the year, when there is little rain, and the temperatures are warmest. If you are planning to visit British Columbia's beautiful countryside, then the autumn is a particularly picturesque time to do so.
The Skiing season peaks in January and February, but some of the resorts - such as Whistler are open and have snow throughout the year.
There are plenty of whale watching trips our into Prince William Sound off the coast, and the best time do go on one is when the whales are migrating in Spring or Autumn. In summer you probably won't see any.