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.
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.
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
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.
I will try to do that with dynamic menu but do you have any idea to figure out how to do that?
Bookmarks