You best option here is to add a form to your project and place a list box on
that form. You can populate the list box with your values and allow the user
to select from that list...
--
HTH...

Jim Thomlinson


"cottage6" wrote:

I've got an inputbox that lets a user type WEEK 1, WEEK 2, WEEK 3, etc. and
the macro then prints whatever range is associated with the week they typed.
Is there a way to provide some kind of selection box the user could click
their choice in, versus an inputbox where they need to type? Thanks for your
help!