Hi All,

I'm currently working on an excel vba application for my local scout group with the prospect of making it open source to the scouting community.

I would like to have a Combo box that will look at a worksheet and populate with a drop down list of Camps the cubs have been on showing a 3 column drop down box.

Example below:

Camp Date |Camp Location | Number of Nights
01/06/2009 | Snowball | 2
06/07/2009 | Strensall Common | 1
09/09/2009 | Snowball | 3

Have seen this done on the net before but cant find the code

Thanks,
Dan