Run macro specified number of times (specified by user)

[lealea1982]

Hello,

I have a macro that 'inserts a new week' on a worksheet when the user clicks on a button. What I'd like from here is...

- User clicks on a button
- A message box pops up asking the user to specifiy how many weeks they require (ideally there'd be 10 checkboxes for 1 week through to 10 weeks and the user could just select one and click ok)
- The macro runs however many times the user specified

Is that something anyone can help with?

Many thanks

[jaslake]

Hi lealea1982

The attached contains a UserForm. You'll need to add your Code at the place indicated.

Please Login or Register  to view this content.