Userform Repeat

[mjbusch1985]

Im just wondering if it's possible to create a Userform that can be used repeatedly but populates consecutive rows until a certain a row is called. It would look something like the image below. If the option box yes was checked then you press the continue button, the same userform repeats and the textbox is populated on the worksheet from say B2 through B12. Once the No is clicked the userform closes. Im just wondering if this is possible? Or will I have to create 10 userforms? Thanks.

Untitled.png

[Norie]

You don't need 10 userforms.

When exactly do you want to put the value from the userform onto the worksheet?

Is it when Continue is pressed?

Please Login or Register  to view this content.

[mjbusch1985]

yeah when I click continue, the textbox will be populated onto B2 and then the Userform will be called again Until all rows are filled or no items are left to be inspected.