Hi, pretty new to macros and was just trying to make a simple one to change the font size of highlighted text. I hit record, changed the font size and then stopped it, and that macro, when activated, did nothing.


If it helps, here's the code for that macro:
Sub Size10()


'
' Size10 Macro
'
'
mySel = Selection.Font.Size
mySel = 10
End Sub


Any help would be appreciated, thanks!

You did something wrong when you recorded the macro. If done correctly this is what you were supposted to find:

You're correct, the code I posted was from one macro that I fooled around with (with 0 knowledge on the topic, as is apparent, lol). But the macros naturally recorded like you wrote it.
For some reason, all of those size macros are working today. Don't know what changed...

That's okay, as long as it works .

I figured out the issue...this makes no sense. The macro works on english (regular left to right font), but when I use hebrew (right to left font) it doesn't work. Any ideas?

Ok managed to solve this myself by googling it. In case anyone else gets stuck with this I learned that apparently VB has different character attributes for right to left languages, and the term bi needs to be added.

So the following change made it work:
(Source: vba - How can I change the font size of non-English words? - Stack Overflow)

Thanks for sharing, always helpful.

Use styles, not macros, for formatting.

The Importance of Styles in Microsoft Word

Thanks, that's a good point. Honestly, I'm used to styles for headings and the likes but in the text itself I often change formatting for clarity (these are study notes), never really thought to make those into styles, interesting.