I was hoping that someone might know how to add pop up windows in excel via a macro in order to
- prompt the user to enter number of the first row in the range
- prompt the user to enter number of the last row in the range
- prompt the user to enter number of printed copies
- print previously defined range of rows (or just one) on printer (label printer) in number of copies as defined before
For example, I am using a workbook to print labels (each row is the label), and when I wish to print from row 5 to row 8, I would like a macro to prompt me to enter number 5 as the first row in the range, and then number 8 as last row in the range, and then specify how many times I want to print out each row (label).
Thank you very much for your attention to this thread, may be you could help me.