+ Reply to Thread
Results 1 to 3 of 3

Create dynamic number of checkboxs on Userform

  1. #1
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Create dynamic number of checkboxs on Userform

    After some research I came up with the following but for some reason it creates the first checkbox with no problem but then stops after that giving me an invalid class string error. This is my first time attempting some "on the fly" userform objects instead of placing them in the originating userform. So what am I missing or doing wrong to have it give me this error?

    Thanks in advance.


    Please Login or Register  to view this content.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Create dynamic number of checkboxs on Userform

    Hi,

    The syntax required is confusing. Try changing:
    Please Login or Register  to view this content.
    I don't know why, but the '.1.' is always required.

    Lewis

  3. #3
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Create dynamic number of checkboxs on Userform

    Okay, well what I ended up doing is added that one, then changed the name of that object to match the amount of label's filled out in the form. Thanks for the lowdown on this.


    Please Login or Register  to view this content.

+ 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. how to create auto number in vba userform?
    By latra23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 03:16 PM
  2. Replies: 1
    Last Post: 10-05-2011, 03:18 PM
  3. Can I create a dynamic chart with a dynamic number of series?
    By SG2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-24-2011, 08:44 AM
  4. How to create dynamic userform or dialog box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-01-2010, 12:49 PM
  5. Create a dynamic UserForm
    By chamdan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2009, 10:13 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