2
votes
Rotate text without rotating border
Just use the Orientation tool on the Alignment dialog Format Cells => Alignment
If you are setting Borders which you need to keep straight, you will need to have your angled text in merged cells.
1
vote
How to assign VBA to a keyboard shortcut in Microsoft Word?
You can assign a macro to a keyboard shortcut in Word rather simply.
Here is my article on the MS website about assigning keyboard shortcuts.
Here are just the steps required to add the keyboard ...
1
vote
Accepted
VBA code to enable three Cells, each in its own worksheet, equal to each other always
In order that the event procedure will not keep calling itself and getting
stuck in an infinite loop, use this VBA command before setting the other
cells to disable event procedures from firing:
...
1
vote
Accepted
Rotate text without rotating border
The only way I can see for having angled text within a square cell,
is to take the text out of the cell.
The text would then be inside a Text Box that will itself be angled,
and the box would be ...
1
vote
Accepted
Remove formula in cell using vba
Add the following to your code after the line h = Replace(g, ",2)", "")
If IsNumeric(Mid(h, 2, 1)) Then
h = Replace(h, "=", "")
End If
It check ...
1
vote
How to properly format combinations generated in VBA script for Excel?
Add the following code before the line lastrow = lastrow + 1
Dim myvalue As String
myvalue = Range("G" & lastrow).Value
While Right(myvalue, 1) = "/&...
1
vote
How can I set Microsoft Word up to change any text encapsulated in `backticks` to monospace?
The closest workaround I know is to make a new character style you can apply by hitting "Ctrl+1" and turn off by hitting "Ctrl+Space".
Open the Styles Pane and click New Style.
...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
vba × 3525microsoft-excel × 2604
macros × 698
worksheet-function × 537
microsoft-excel-2010 × 511
microsoft-word × 265
microsoft-excel-2007 × 247
microsoft-outlook × 147
microsoft-excel-2013 × 135
microsoft-excel-2016 × 134
microsoft-access × 78
microsoft-office × 62
microsoft-powerpoint × 54
charts × 49
email × 45
microsoft-outlook-2010 × 37
conditional-formatting × 34
microsoft-word-2010 × 32
pivot-table × 30
csv × 26
vlookup × 26
microsoft-outlook-2013 × 24
windows × 23
vbscript × 21
microsoft-excel-2003 × 21