Help needed learning basic excel vba

**royUK** · 02-23-2009, 08:10 AM

There are no cells in a userform. What exactly do you want to do?

**excelkeechak** · 02-25-2009, 10:41 PM

I m learning excel vba. My problem is that i m not able to work with cells using loops. i m interested to fiddle around with cells.I want the correct syntax and usage of using cells with all the loops in different situations.

I want the help regarding the Usage of CELLS in vba.For example i want to display a message box with the data in two columns say for example, In Col A A,b,c,d,e, etc.. and in COL B the values are Apple,Boy,Cat etc.

I want to display the message box as
A for Apple
B for Boy and like wise. its just an example i had given. I hope u got my requirement.

how can i loop and how can i display it.I also want the answer not for this query but to handle cells in all situations. Hope i had given my problem

Thanks

**shg** · 02-25-2009, 10:47 PM

You might look at http://www.dummies.com/store/product...764574124.html. I don't know the book, but Walkenbach is a good author.

**royUK** · 02-26-2009, 04:27 AM

This is one way

   Dim rng    As Range
    Dim r      As Long
    Dim msg    As String

    'range containing data
    Set rng = ActiveSheet.Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp))
    'build the message
    For r = 1 To rng.Rows.Count
        If msg = "" Then
            msg = Cells(r, 1).Value & ": " & Cells(r, 2).Value
        Else: msg = msg & vbNewLine & Cells(r, 1).Value & ": " & Cells(r, 2).Value
        End If
    Next r
    'display the message
    MsgBox msg