Re-using the same userform

[Manisha]

In excel, i want to display the same user form just after
i have used it. how?

 

[Bob Phillips]

Not sure I understand, but why not just show it again.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Sub Tester1()
Dim uform1 As UserForm1
Dim uform2 As UserForm1
Set uform1 = New UserForm1
Set uform2 = New UserForm1
uform1.Show
uform2.Show
End Sub

Uform2 won't show until uform1 is dropped. (hidden or unloaded)

Not sure if this is what you want to do.