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.
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
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: