Choose your language

Formatting Text

Basic Exercise

Statement

Using the macro recorder, create a macro to format texts. Final texts should be: Centralized, Bold, Font: Verdana and Font size: 11.

Suggested Concepts:

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.

Show Answer
Download exercise Download answer

INTRODUCTION

VBA Exercises

BASIC

VBA Formatting Text VBA Color Selected VBA Metric Converter VBA Do Loop Sum VBA Sum of Powers VBA Sort Array VBA Simple Loop VBA Harmonic Mean VBA Alternate Color VBA Even or Odd VBA First Capital Letter VBA Intersection VBA Ascending Order VBA Concatenate VBA Select Case VBA Columns to Lines VBA Making an Addition VBA Offset Resize VBA Search and Color VBA Current Region VBA Simple Email

INTERMEDIATE

VBA Message Box VBA Final Score VBA Factorial Function VBA Infinite Series VBA Count dollar bills VBA Prime Number VBA If Insert Cell VBA Text to Columns VBA Even and Odd VBA Ballot Box

ADVANCED

VBA Recursive Factorial VBA Hangman Game VBA HTML Email

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.

© 2024 SuperExcelVBA | ABOUT

Protected by Copyscape