Need help writing a VBA function that prints a loop

[pab88]

Hi everyone,
I am messing around with Excel and as an assignment I need to create a VBA function that prints my name 10 times in a loop. Then I need to create a button that will trigger the function. How can I do this?

I tried:

Module Hello
Sub Main()
MsgBox ("Hi, my name is Pat")
End Sub
End Module

But it did not work. I am not sure how to get the button to work either. If you could offer any help I would really appreciate it. thank you!

 

[JackDanIce]

Welcome to the board.

For the code, try:

Sub Main()

    Dim x   As Long
    
    Application.ScreenUpdating = False
    
    For x = 1 To 10
        Cells(x, 1).Value = "Hi, my name is Pat"
    Next x
    
    Application.ScreenUpdating = True

End Sub

You can search online on how to attach a macro to a button: http://tinyurl.com/y8426jmz