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!

Data Validation with a list of those values, then trap the value with
worksheet change event code to fire your code.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"cottage6" wrote in message
...
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!

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!