Change the size of button present on Add-ins Custom Toolbar

Kuldeep Patel

New member
Joined
Jul 1, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
1906
Hello ,

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


Code:
part of the code:
Sub Auto_Open()
   
   '----- part of the code
    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)
   '---- part of the code

End Sub

oControl is CommandBarControl

I have tried oControl.Height and oControl.Width but it did not help.Also Not able to find solution.

Please, help me with this. Thanks
 
Last edited by a moderator:
Hi
please wrap code with code tags ( #button). Thanks
 
Thanks!
Can you please provide the example/details of how to wrap code with code tags #button?
 
I have done it for you. Edit your opening post to see how I did it.
 
Please, help me with this. Not able to make the buttons larger present on Add ins Custom Toolbar tab. Thanks
 
Back
Top