+ Reply to Thread
Results 1 to 4 of 4

Dynamic Checkbox's in a UserForm

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    230

    Dynamic Checkbox's in a UserForm

    I'm trying to add dynamic checkbox's to my userform and I can't seem to get it to work.

    I generate the list on my "FolderList" tab from existing folder structure and they are seperated into the columns of the tabs I want them to go on


    HTML Code: 
    When I activate the userform I generate the checkbox's

    HTML Code: 
    I want to be able to check a few of the boxes on one tab, then press the "insert sheets" button and everything that's checked is inserted into the current workbook. I can insert if I have named checkboxe's (see UserForm1) but not dynamic.

    any help would be greatly appreciated.

    ... and if you can do it without generating a list in the workbook I would be more than grateful.
    Attached Files Attached Files
    Last edited by Cobra17; 08-18-2020 at 11:33 AM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Dynamic Checkbox's in a UserForm

    It looks like adding the checkboxes dynamically is stopping the event handler for the Command Button working.

    I would suggest that you create all your check boxes at the design stage and hide the ones that you do not need.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    230

    Re: Dynamic Checkbox's in a UserForm

    It seems to be working, i think. if i add a msgbox at the start of my "InsertTab0_Click" it does pop up.

    This is what i've come up with so far, but its not working correctly. Since i'm generating my checkbox captions from my file names, I'm just adding the .xlsm back on and the file path if the checkbox value is "True"

    HTML Code: 

  4. #4
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    230

    Re: Dynamic Checkbox's in a UserForm

    got it... stripped it down a little but it works.

    HTML Code: 

+ 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. [SOLVED] Set Userform Checkbox value to True if CheckBox.Caption string is found in another String
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2018, 03:39 PM
  2. [SOLVED] Make Worksheet Active-X CheckBox value same as Userform CheckBox value
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 08:23 AM
  3. Creating dynamic userform rely on dynamic checkbox selection
    By END93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2016, 06:39 PM
  4. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  5. Dynamic Userform (resizing based on checkbox selection)
    By gazza365 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2011, 04:50 PM
  6. Dynamic onclick for checkbox
    By capetownandre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2009, 06:10 AM
  7. add dynamic control (checkbox)
    By Pluut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 01:19 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