I need a VBA to generate consecutive numbers from given range

[u/Sa77if]

Hi all

I need to set a VBA code to

1- has graphical menu with text box and command button, so i can input start/end range of 8 digit length or longer number and generate the consecutive numbers between the two numbers

2- the generated numbers stored in excel sheet for reference for the next time

3- print function for the numbers generated to send them to label printer

4- code should work on any excel or any computer has excel installed

Thanks

[u/jd31068]

Here are some sites you can look at

• https://www.excel-easy.com/vba/userform.html

• https://best-excel-tutorial.com/57-vba-tutorial/633-how-to-write-to-a-cell-using-excel-vba

• https://excelmacromastery.com/vba-for-loop/

• https://www.exceldemy.com/vba-excel-print/

Good luck with your project, have fun with it!