View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Change Code Windows

ThisWorkbook.VBProject.VBComponents("UserForm1").D esignerWindow
--
- K Dales


"BillCPA" wrote:

I am using the following code to set certain parameters on my code windows:

Dim cmpComponent As VBIDE.VBComponent
Dim cmpComponents As VBIDE.VBComponents
Dim cmpName As String
Dim xx As Integer
Set cmpComponents = ThisWorkbook.VBProject.VBComponents

For Each cmpComponent In cmpComponents
cmpName = ThisWorkbook.VBProject.VBComponents(cmpComponent.N ame).Name

ThisWorkbook.VBProject.VBComponents(cmpName).CodeM odule.CodePane.Window.Top =
12
.
.

ThisWorkbook.VBProject.VBComponents(cmpName).CodeM odule.CodePane.Window.Close
Next cmpComponent

This works for the code windows, but not for the user forms. What would I
need to change to manipulate the form windows?

--
Bill @ UAMS