Results 1 to 7 of 7

Select the record for display

Threaded View

  1. #1
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Select the record for display

    Hello masters,

    I have a report in listbox shows a list of entries made.
    I need that one to be edited and save back.
    I created pretty report in listbox. And
    when I click it I need it to display in a Textbox so that I can edit
    and save back.

    This is the code i use to load in textbox.
    Please help me.
    Private Sub Results_Click()
    Dim c As Range
        If Me.Results.ListIndex = -1 Then    'not selected
            MsgBox " No selection made"
        ElseIf Me.Results.ListIndex >= 1 Then    'User has selected
            r = Me.Results.ListIndex
    
     Set c = Cells.FindNext(c)
     
            With Me
                .Box1.Value = Results.List(r, 0)
                .Box2.Value = Results.List(r, 1)
                .Box3.Value = Results.List(r, 2)
                .Box4.Value = Results.List(r, 3)
                      
            End With
        End If
    End Sub
    Please help me.
    Regards, Charles P
    Attached Files Attached Files
    Last edited by ebin charles; 06-19-2011 at 06:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1