populate a list from a value in another list or combo box

Hi All,

I'm new here (and to excel) so hope I have posted this in the right palce.

I have a worksheet in which Col. A contains the names of London boroughs and col. B contains the name of each Ward in that borough.

I'd like to create a list (or combo) box showing all the London boroughs, and a second list (or combo) box which will show all the Wards for the Borough selected in the London list (combo) box. I'd also like the option to be able to select all the Wards for the borough selected so that they can be used in a chart\graph.

I have no idea to do this.....and am hoping that someone o=here can at least point me in the right direction.

Thanks in advance

XLV