• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Application input box to print

Status
Not open for further replies.
Hi
I have this code and when I get to input box that said "what page you want to print?", then I type 2, 4, 5 but it does not print anything. But if you leave 1 in the box then it print the page 1.

Here is the code: This is just the part of the code.

pNr = Application.InputBox("What page you want to print?", "Printing a Page.", 1, , , , 1)


thank you
 
RDEXCEL2020
For Your how do I ...
You should change type to 2 in Your Inputbox.
After that, You can enter page numbers like
1, 3, 4, 5, 7.

Is this duplicate with
 
Last edited:
Hi Vletm
I did not know i have posted it. I guess your right. My apology.
I haven’t resolved the issue yet.
Then, if you see the sample i have attached and try and its not working.
 
RDEXCEL2020
With Your original code, You could give only ONE number.
If You would change it, that You could give a string (many numbers as You've dreamed) then You could 'pick' those page-number from it.
Your 'sample' won't work as You've dreamed ( and You have not attached anything ).
 
Status
Not open for further replies.
Back
Top