PDA

View Full Version : how to make CommandButton1.Rotation = 90 in office 2016



kofatoto
08-23-2017, 03:31 AM
hello
how to make CommandButton1.Rotation = 90 in office 2016
please help

D_Marcel
08-23-2017, 04:00 AM
There is not a "rotate" or "rotation" property to the form controls or to the ActiveX controls. How about this?

https://stackoverflow.com/questions/27390420/rotate-text-90-degrees-in-a-vba-button

Regards,

Douglas

p45cal
08-23-2017, 04:13 AM
D_Marcel is right, but in the link he refers to,you do not need to save the bitmap (in fact i suspect if saved, the bitmap will need to be available on the computer where Excel is being used?), you can instead copy the the rotated picture into the clipboard, and then in the Properties of the button, click on the Picture property, then Crtl+v to paste it, it will appear on the button and be saved with the Excel file.
20149

kofatoto
08-23-2017, 10:03 AM
thanks
but i want rotation

p45cal
08-23-2017, 10:49 AM
but i want rotationTough:
There is not a "rotate" or "rotation" property to the form controls or to the ActiveX controls.