Rotate the text within any range of 360 degrees

[VDS]

@Dear All,

For rotating text, there is an option for "Orientation in the Alignment Tab. However, range is limited from 90 to -90. I want to rotate text within any range of 360 Degrees. Just like X and Y Axis of 4 coordinates with option for user entry.

For example, Typing "MANGO" and apply the rage beyond -90, display text something like a mirror image of the text.

I tried with the below code as suggested by Mr Jon Von Hayden

Public Function ReverseText(ByVal strText As String) As String
    Dim strResult   As String
    Dim lngChar     As Long
  
    strResult = vbNullString
  
    If Len(strText) Then
        For lngChar = Len(strText) To 1 Step -1
            strResult = strResult & Mid$(strText, lngChar, 1)
        Next lngChar
    End If
  
    ReverseText = strResult
End Function

The rage of this function is fixed. Is it possible to rotate text within any range of 360 degrees with user entry / help of macro ?

VDS

 

[shrivallabha]

If you mean cell text then it will be within that limit only.

WordArt can be rotated though.

 

[VDS]

@Srivallabha,

Thanks for your reply. Will revert shortly.


VDS

 

[Hui]

You can Reverse the text and the apply the limited rotations to achieve a simulated 360 Deg rotation
needs VBA and can't be done using a Function as Functions can't change the worksheet

 

[Debraj]

Is this what you are looking for!!!

 

[VDS]

@ Debrai/ Huli

My purpose is to display 4 APPLES Just like a diamond shape. Pls see the attacehd file. Dont know how the output will be. It is only a guess. First 2 rows can be done with the orientation. How to do with the second row.

VDS

 

[bobhc]

Good day VDS

Not sure why you need to do this, your viewers are going to end up at the optomirised. But you can do it with the function on the alignment tab on the ribbon

 

[VDS]

Bob Sir,

Thank you & this is nice. But when I apply the border lines, it displays so many lines. This is required to develop a template / Logo as per the attachment. Later on this template can be used for different offices, by changing text.


VDS

 

[bobhc]

Like this

 

[VDS]

@Bob sir,

All border lines are to be highlighted in rectangle or square shape. No fill colour in the column and text to be displayed 45 and - 45 degrees.



VDS

 

[bobhc]

Your actual needs are for you to sort out I was just asking if the logo I had done was what you were after, if it is then you can design your own using power point

 

[VDS]

@ Bob Sir,

Sure. Thank you for the suggestion.


VDS