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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.