Results 1 to 5 of 5

Thread: Button to add new checkbox in ribbon

  1. #1

    Button to add new checkbox in ribbon



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I created a custom tab and I want to add checkbox in that tab by clicking the button

    Do you have any idea to do that?
    Thank you.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,807
    Articles
    0
    Excel Version
    O365
    I think you would have to have the checkbox already setup and non-visible, and the callback code on your button would set that object to visible.

  3. #3
    Thank you for the reply Bob,

    The problem is if I hide one checkbox and make it visible with the button but what happened when I want to create another checkbox with different name
    Best Regards

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,807
    Articles
    0
    Excel Version
    O365
    You cannot add controls to the ribbon on the fly with VBA, just can't do it. You either have to know how many you might need and create them up-front and use the technique I suggest, or use some other approach, such as a dynamic menu that you can add to on the fly.

  5. #5
    I will try to do that with dynamic menu but do you have any idea to figure out how to do that?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •