Consulting

Results 1 to 5 of 5

Thread: how to make CommandButton1.Rotation = 90 in office 2016

  1. #1

    how to make CommandButton1.Rotation = 90 in office 2016

    hello
    how to make CommandButton1.Rotation = 90 in office 2016
    please help

  2. #2
    VBAX Contributor D_Marcel's Avatar
    Joined
    Feb 2012
    Location
    Tokyo
    Posts
    117
    Location
    There is not a "rotate" or "rotation" property to the form controls or to the ActiveX controls. How about this?

    https://stackoverflow.com/questions/...n-a-vba-button

    Regards,

    Douglas
    "The only good is knowledge and the only evil is ignorance". Socrates

  3. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    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.
    2017-08-23_121230.JPG
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  4. #4
    thanks
    but i want rotation

  5. #5
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Quote Originally Posted by kofatoto View Post
    but i want rotation
    Tough:
    Quote Originally Posted by D_Marcel View Post
    There is not a "rotate" or "rotation" property to the form controls or to the ActiveX controls.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •