Capturing & Using Number of Copies to Print

I am brand new to Excel macros, and I would like to create a macro to enable a user to enter the number of copies to print, and then print that number of copies of a predetermined range in a spreadsheet. My InputBox routine works fine, but I don't know how to use the info I just captured. The code I have so far is as follows, but I guess I don’t know where this number is stored, or how to use it in a print statement. Needless to say, this routine doesn’t print the number of copies entered by the user.

Sub TestPrint()
' Ask user to input the number of copies to be printed.
Dim Message, Title, Default, MyValue
Message = "Please enter the number of copies to print"    ' Set prompt.
Title = "Number of copies"    ' Set title.
Default = "2"    ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)
Sheets("PaidOut").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True


End Sub

Re: Capturing & Using Number of Copies to Print

Thanks, Stefan G !
It works fine, although with a little flicker, which I can get out. I knew it had to be something simple. Thanks a million. Problem solved...