+ Reply to Thread
Results 1 to 2 of 2

Dynamically place add a frame within an exisiting frame

  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.
    Please Login or Register  to view this content.
    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