Userform takes variable data

[vin1]

Hi i got some problem with my userform.

In my project i have to run a userform 2 times to do the same actions for a diffrent sheet.
The userform takes its sheet from a number (1 or 2)
However i am not sure how to let the userform know which number he should get at initialization.

To keep it simple i want for the first time the userform runs i need an integer number 1 and the second time it runs i need an integer number 2.

[snb]

In that case you can load the userform and use it's tag property in the activate event to indicate that it's using integer 1,
you can 'close' the userform using 'hide'. The next time you open the userform you can test it's tag property.

Sub snb()
   userform_snb.show

   userform_snb.show         '    open the userform for the second time
End sub

Private Sub userform_activate()
  tag=val(tag)+1
  Textbox1.Text=sheets(val(tag)).range("A1")
End Sub

Private Sub knop_sluit_Click()
  Hide
End Sub

[vin1]

Do you mean activate event by the init event?

Also re-using the same userform is not the best way. it means i have to empty all variables and run the userform again. but then with a diffrent integer stored.
so its easyer to empty all variables and simply get 1 integer from a diffrent module into reloaded userform.
But im not sure wether thats possible.

[royUK]

Use a CheckBox to determine which to use