PDA

View Full Version : Solved: Multiple versions of UserForm



PMHCSLtd
06-22-2006, 06:55 AM
Is it possible to open multiple copies of the same userform? If so how :doh: !

Killian
06-23-2006, 01:42 AM
Hi and welcome to VBAX :hi:

A userform is a class (with a GUI) so it can be instanced in the same way.'assuming you have created a form called "UserForm1"
Dim f As UserForm1

Set f = New UserForm1
f.ShowFor multiple instances, you will, of course, have to account for the "modal" behaviour of forms.

PMHCSLtd
06-23-2006, 02:48 AM
Works a treat, thank you! :bow: