VBA function in excel that uses loop

[cjgovi]

Hi

I was asked to:

Create a VBA function in excel that uses loop and that prints "Hello World" 10 times.


I have searched the internet but cannot find anything

Do you know how to do this

thank you advance!

 

[Fazza]

go to google & search for your thread title: VBA function in excel that uses loop
there are many good solutions

 

[daverunt]

Do your own homework

 

[louisH]

Hi,

I don't know what you mean by "printing", but here's the following :

    For i = 1 To 10
    
        'To display it on screen
        
        MsgBox "Hello World", Title:="Do your homework yourself"
        
        'To write it in cells
        
        Cells(i, 1).Value = "Hello World"
        
    Next i

 

[cjgovi]

hi...thank you all - i found it after Fazza reply..thanks again

 

[Fazza]

Well done. Google & the internet are a fantastic combination for learning. All the best