Place a list box in a cell
 

Look at Data=Validation in xl97 - xl2003. Choose the list option.

--
Regards,
Tom Ogilvy


"Hank Youngerman" wrote:

I know how to put a control on a page, and pass the values in that
control to a module.

What I want to do is simply put a list box or combo box in a cell, so
that the user, instead of typing a value in the cell, clicks on the
drop-down arrow. The value is then placed in that cell and used by
the spreadsheet like it would any other cell.