Change the size of button present on Add-ins Custom Toolbar (VBA Code, Excel)

Hello,

Need help with below query as I am new to Excel, VBA.

I have created buttons with the help of VBA Code on Add-ins. How can I make the button size larger (change the size)? I have tried methods like height and width but they did not help me.

part of the code:

Sub Auto_Open()
    x = x + 1
    Set oControl = oBar.Controls.Add(ID:=specifyID, Before:=x)
    oControl.OnAction = "Specify Action" 
    oControl.FaceId = SpecifyFaceID
    oControl.Caption = "Specify Caption" '(Not provided any values)
End Sub

oControl is CommandBarControl

I have tried oControl.Height and oControl.Width but it did not help. Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here I have done it for you this time.)

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

https://www.excelguru.ca/forums/show...Custom-Toolbar

why not just set the button size in the properties window? do you know how to do that?

what is oBar?

oh, now i see why your height and width didn't work as i was thinking this was a commandbutton. i would recommend that you use https://www.andypope.info/vba/ribboneditor.htm andy popes ribbonx designer. that might be able to change the size of the buttons. i used it in an AddIn that i created and needed to change the icons. but you should be able to set the size using that program. let me know if you need help, note that andy gives an email address (don't have it) that you can communicate with him on questions.

found his address:

To contact me directly please use
Email: andy@andypope.info

Currently you are using the old CommandBar object to generate the button. By default those buttons are added to groups in the AddIns tab. I don't believe you can control the size the button when it is automatically placed there.

If you use ribbon xml to create your own tab/group/buttons you can use the size property of Large. You can edit the xml with customui editor or the ribbon editor.