+ Reply to Thread
Results 1 to 2 of 2

Dynamically place add a frame within an exisiting frame

Hybrid View

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    anamosa, iowa
    MS-Off Ver
    Excel 2007
    Posts
    34

    Dynamically place add a frame within an exisiting frame

    I am trying to dynamically add a frame to a userform within an existing frame. when my code reads the line Set NewFrame1 = UserForm.Frame1.Controls.Add(Forms.Frame.1,"NewFrame"), it errors out. I am doing something wrong? can you not add a frame within a frame dynamically?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Dynamically place add a frame within an exisiting frame

    Forms.Frame.1 should be in quotes and UserForm should be Me if the code is in the userform module.
    Set NewFrame1 = Me.Frame1.Controls.Add("Forms.Frame.1", "NewFrame")
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. place dynamically created controls in row and column into the userform with in the frame
    By gokulkrishi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2016, 01:38 AM
  2. Private sub textbox1_exit in a frame/not in a frame, different behavior?
    By ualdriver in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2015, 09:14 AM
  3. [SOLVED] Looping through controls by frame on userform (frame within a frame)
    By njs27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 10:21 AM
  4. Selecting the frame Dynamically
    By Laurelb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 10:17 AM
  5. [SOLVED] userForm -> Frame 'top' value limited. Dynamically created controls,
    By kropeck in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 08-19-2013, 09:04 AM
  6. Dynamically changing the Frame Size
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2011, 05:02 PM
  7. How to attach legend frame to chart frame?
    By holg3r in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2005, 06:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1