The forms MUST be modeless. (thus cant do this in Excel97)

In the code for the form make sure you dont the the form's name but (if
needed) refer to Me.ComboBox1 .etc..


Sub TenForms()
Dim myforms(0 To 9) As UserForm1
Dim i
For i = 0 To 9
Set myforms(i) = New UserForm1
With myforms(i)
.Show vbModeless
.Top = i * 10
.Left = i * 10
.Caption = "Myform" & i
End With
Next
End Sub




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Warrio" wrote:

Hello



Is it possible to show many instances a form many times?



If the form is already displayed once, and I try to do (Form.Show) one
more time, an error message appears and tells that I can't display it
twice.



Thanks for any suggestion