What are some examples of macros in Visual Basic?

Can you give me some examples of macros in Visual Basic?

Sure! One common example is automating repetitive tasks in Excel, like formatting cells or generating reports.

How do I create a simple macro in Excel using Visual Basic?

You can create a macro by opening the VBA editor, inserting a new module, and writing your code. Would you like a sample code?

Yes, please provide a sample code for a basic macro.

Here's a simple example:

Sub FormatCells()
    Range("A1:A10").Font.Bold = True
    Range("A1:A10").Interior.Color = RGB(255, 255, 0)
End Sub

This macro makes the text in cells A1 to A10 bold and changes the background color to yellow.

That looks great! Can I run this macro automatically when I open the workbook?

Yes, you can use the Workbook_Open event to run the macro automatically. Just place your macro call inside that event.