Hot answers tagged

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.
user avatar
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 ...
user avatar
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: ...
user avatar
  • 412k
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 ...
user avatar
  • 412k
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 ...
user avatar
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) = "/&...
user avatar
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. ...
user avatar
  • 689

Only top scored, non community-wiki answers of a minimum length are eligible