Using the macro recorder, create a macro to format texts. Final texts should be: Centralized, Bold, Font: Verdana and Font size: 11.
Remember that in most cases there is more than one way to solve the problem.
Tip: Try not to make any mistakes while writing your macro to avoid unnecessary code generation.
Go to the Developer tab
Select Use Relative References
Click Record Macro
Name the macro and click OK
Return to the Home tab, select a cell with text ("A2" for instance), and follow the instructions of the problem (centralize, coloque em Negrito, mude a fonte para Verdana e altere o tamanho para 11)
Stop the macro recording
Now to use the code, just select an unformatted text ("A3" for example) and run the macro
SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.
Excel ® is a registered trademark of the Microsoft Corporation.
© 2019 SuperExcelVBA | ABOUT
Thank you for contributing. A message was sent reporting your comment.