+ Reply to Thread
Results 1 to 3 of 3

Adding controls programatically to a Userform 'page' in a multipage control

  1. 08-14-2024, 11:50 AM #1
    gssi.chinner
    gssi.chinner is offline
    Registered User
    Join Date
    05-22-2014
    Location
    Collingwood, ON, Canada
    MS-Off Ver
    2010
    Posts
    5

    Adding controls programatically to a Userform 'page' in a multipage control

    I am trying to programmatically add textboxes to a page in VBA. So far, all I get is an error suggesting I am using the wrong text to complete the call to the creation routine: pgeTest.Controls.ADD "Forms.Textbox", "txtbxTst", True

    Can someone suggest a reference to documentation supporting this process?
    Reply With QuoteRegister To Reply
  2. 08-14-2024, 12:02 PM #2
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,928

    Re: Adding controls programatically to a Userform 'page' in a multipage control

    Something like
    Please Login or Register  to view this content.

    https://learn.microsoft.com/en-us/of...ethods-example
    Last edited by ByteMarks; 08-14-2024 at 12:04 PM.
    Reply With QuoteRegister To Reply
  3. 08-15-2024, 05:26 AM #3
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,409

    Re: Adding controls programatically to a Userform 'page' in a multipage control

    see attached from my archive - an example of constructing a dynamic 'Likert' questionnaire scores.
    Add or subtract questions in blocks of ten - the multipage will resize accordingly.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multipage Control - Page Contents not changing with coded page change
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-26-2022, 08:20 PM
  2. [SOLVED] Cant get ActiveControl.name of controls on Multipage control in UserForm
    By zsylvainz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2021, 03:03 AM
  3. Copy controls of one page of a multipage to another
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 02:42 AM
  4. [SOLVED] Multipage form: Referencing controls on one page
    By Post Tenebras Lux in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2006, 02:45 PM
  5. [SOLVED] Adding controls to each page in a multipage form
    By michael fuller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2006, 05:50 PM
  6. [SOLVED] Looping through controls on a MultiPage control
    By Paul Martin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2005, 01:06 AM
  7. [SOLVED] Progmatically adding controls in multipage
    By Ajit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2005, 06:06 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1