+ Reply to Thread
Results 1 to 4 of 4

Button to create new checkboxes

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Button to create new checkboxes

    Good morning, i came here to ask if theres any way i can possibly do the following, i have a user form with some checkboxes, and im curious if theres a way to create a button that creates new checkboxes in the program without having to do it manually in the vba everytime i have to add a new checkbox.


    Thanks in advance

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,669

    Re: Button to create new checkboxes

    This is an example of how to create a checkbox with a button, but you have this problem of what do you want the checkbox to do if the user checks it?

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-04-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    8

    Re: Button to create new checkboxes

    basicly i have a userform, with 4 titles, that behing, International Messages, Nacional Messages, M2M Service, and M2M Roam, and they are all conected to subitems(the checkboxes) like for e.g "M2M Roam Spain", "M2M Roam German", wich are compared to the ones on the excel sheet to see if they exist, but the thing is the list is diferent each month, so im trying to make this button to save the trouble of having to create the checkboxes in vba everytime i need to add new ones each month

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,669

    Re: Button to create new checkboxes

    Your explanation is still missing some key points.

    How will you know what the subitems are that you need to create checkboxes for?

    What is supposed to happen when you check a box?

    It might help if you attach your file.

+ 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] check and uncheck certain checkboxes with a button
    By 2mi3 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-29-2015, 03:55 PM
  2. Checkboxes to enable button
    By ryryAP2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2014, 08:21 PM
  3. [SOLVED] Checkboxes and button on userform?
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-24-2013, 11:44 AM
  4. Please Help! how to create command button to check a column of checkboxes
    By cnbv in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2013, 01:08 PM
  5. Select All or None of Checkboxes using Radio Button
    By smk224 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2010, 04:53 AM
  6. option button updates 4 checkboxes?
    By CParnell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2009, 03:38 PM
  7. checkboxes command button
    By spoko in forum Excel General
    Replies: 10
    Last Post: 07-21-2007, 10:20 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