How to put into userform that can select number of page to print using userform?

Hi Guys,

How to put into userform that can select number of page to print using userform?

I attched sample file with explanation of desired output.>>>Sample userform.xlsm

Kindly help me build userform.

Hi

Do you want to print the same page numerous times? Or do you want to select pages to print? (Eg. print page 6 - 13)
Because your code appears to do the first, but your question seems to be the latter.

Anyway, try this:

Please Login or Register  to view this content.

Or this:

Please Login or Register  to view this content.

Best regards
Per Erik

Hi,

I want to print this several times. By changing value of a3 the page will be differ. This userform range is intended for cell a3. Using my old code i can print 1-10 simultaneously. What i want is to use userfor to select what number to be printed. Ex. I want to print only 1 - 3 i would like to en enter in user form 1 to 3.

I have not try your code yet as don't have printer here

OK, I think I've got it:

Please Login or Register  to view this content.

Hi,

Thank you for your ideas. I made it correct now. I guess you miss the value of "r" on your 3rd vba code.

Your first VBA code is correct except the value of range.

Please Login or Register  to view this content.

Anyway thank you very much, you help me a lot.

I will add your reputation.