Book1.xlsm
Attached is an example. I have a userform that switches to sheet 2 when opened. Then the two values from the userform are pasted into sheet 2. When the userform is closed, I want to generate a set of random numbers in column A of sheet 1 without switching back to that sheet but using the values in cells C4 and H7 of sheet 2.
Please let me know what is incorrect with my vba for this.
Bookmarks