Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have couple of 100 templates and i need to make a global change to all
(Need to add a frame on 3rd tab of the multipage). With the code below i am able to add frame on the form but could not figure out how to add the same frame on the 3rd tab of the multipage. Suggestions will be greaty appreciated. Sub Add_Control_Testing(Wkb_Name As String, Form_Name As String) ' Declare variables. Dim myForm As Object Dim myFrame As Object ' to manipulate the UserForm. Set myForm = Workbooks(Wkb_Name).VBProject.VBComponents.Item(Fo rm_Name ) 'Adding a frame Set myFrame = myForm.Designer.Controls.Add("Forms.Frame.1") With myFrame .Name = "frame_1" .Top = 180 .Left = 390 .Height = 60 .Width = 202 .BorderStyle = 1 End With End Sub -- Ajit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically Adding Textbox To Frame | Excel Worksheet Functions | |||
Progmatically adding controls in multipage | Excel Programming | |||
Adding checkbox within a frame | Excel Programming | |||
need help understanding syntax for adding a page to multipage | Excel Programming | |||
Adding components to multipage programatically | Excel Programming |