Thanks Skip. I prefer the former as well. I'm trying to delete forms UserForm21 UserForm22 UserForm23 using the following code:
Sub Remove_Form()
Dim i As Integer
Dim s As String
For i = 21 To 23
s = "UserForm" & "i"
Application.VBE.ActiveVBProject.VBComponents.Remove...
Andy -
You've confirmed the suspicion I've had all along.
I am able to do what I want but I have to use software that few people know about. It's called APL.
For now I will be looking to get VB.
Thanks for your reply.
-Mark
Thanks for your responses but this isn't doing it for me. I'm trying to create a pure window in code with the intention of adding controls later, also in code. The underlying application is Excel.
See "UserForm Window" in the VBA help files. There, it says "Each form window has a Maximize...
How do I create a userform window (not dialogue box) with maximize, restore, & close buttons in the title bar? I want to do this under program control.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.