How to use macro vba excel bolding this specific text at footer? Need some help with thanks first~

CodePudding user response：

That looks like the right footer. To reference the value of the right footer for the current worksheet in VBA, use:

myString = ActiveSheet.PageSetup.RightFooter

I do not know, and you haven't said exactly how "August" is generated. It could be a constant string, a variable, a macro, etc...

If you wish to bold all month values (i.e. August in this case) in all worksheets, all you need to do is edit your right footer, and place &B directive before and after the month, or whatever generates the month value.

For example:

End of Statement : &BAugust&B

This change will apply to all sheets, and not just the current sheet.

CodePudding user response：

when you value the footer with your text, use this construction:

YourSheet.PageSetup.RightFooter = "End of Statement : &""-,Bold""" &  ExportForm.cbMonth.Text