In this post I will demonstrate how you can use Excel VBA to loop through certain rows on your worksheet, and then display their value.
First start off by entering a value in Column “A” of rows 1-14 (like in the following image:)
Also add a button called by default “Button1” and enter the following VBA code:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
Sub Button1_Click() Dim intRow As Integer For intRow = 1 To 14 MsgBox Range("A" & intRow) Next MsgBox "End.", vbInformation, "Complete" End Sub |
Watch it now:
Let me know if you have any questions
****************************************************
|






