Hi all,

I've been asked to create a document with two drop-down menus. The first specifies a column to search, the second a specific date. So, for instance, on one drop down the use might select 'Invitation To Tender Date', and on the second 'October 2008'. Thereafter all dates in the 'Invitation To Tender' column are filtered to October 2008 (why people can't do this manually I don't know!).

I'd quite like to use Combo Boxes placed directly on the sheet to do this. However, I'm not quite sure how to hook up the VBA to a Combo Box on a sheet.

My question is: will I need to place the Combo Boxes in a user form to allow them to be 'VBAed', are can I somehow connect them from the sheet. Or if I want to have sheet-based drop downs can this be done with validation drop-downs?

Hope that makes sense - any advice much appreciated!

TIA,

SamuelT