Can a CommandButton be made round vs square

[birdieman]

Was wondering if a CommandButton on a userform be made into a circle -- either thru code or the properties window (i looked but did not see an option in the properties window for a round button).

thanks

 

[JLGWhiz]

A standard command button control selected from either the Form Controls tool box or the Active-x tool box cannot be reshaped to a circle. But you can use a circle from the shapes selections to use in the same fashion as a button. You just have to build the button yourself including the text in the shape text frame and then use the shape click event to execute code. The link below will give you some of what you need to know.
https://msdn.microsoft.com/en-us/library/bb211457(v=office.12).aspx

 

[birdieman]

Thanks JLG -- will check it out

 

[My Aswer Is This]

Create a Circle and save it as a image and put the image on your UserForm and assign a script to the image.

 

[Jaafar Tribak]

You cannot reshape a control on an office userform ... but if you are adventusrous, you may chheck out this :