I've got the number now from an input box, but how do I get excel to use that
number when running the macro? (I dont think I'm familiar with a how to use
"a CASE statement to run the selected one")
Thanks

"Gary''s Student" wrote:

Use an inputbox to get a number and then a CASE statement to run the selected
one
--
Gary''s Student
gsnu200711