Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Code Windows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Windows Visible Property - Code Help | Excel Discussion (Misc queries) | |||
Viewing Access Code in Windows 2000 | Excel Discussion (Misc queries) | |||
VBA Code Windows | Excel Discussion (Misc queries) | |||
Running windows command from a VB code | Excel Programming | |||
Code for locking windows | Excel Programming |