The good news is that you can use a combo box (very similar to a data
validation drop down list) and set the number of items displayed.

The bad news is that I don't have Excel 2007 and have no idea where combo
boxes are to be found. In prevous versions they were 2 mouse clicks away.

From a previous post of mine several threads down...

You are going to love how XL2007 hid this one... NOT!!!

Click the Office button (the big round thing in the upper left corner) and
select Popular on the left hand panel. Next, make sure there is a check mark
in the "Show Developer tab in the Ribbon" item and then click OK. This will
add a Developer tab to the Ribbon. Select it and click the Insert icon in
the Controls section. Your Form and ActiveX controls are both located there.

Rick