+ Reply to Thread
Results 1 to 2 of 2

How can i edit the data at run time

Hybrid View

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    cheenai
    MS-Off Ver
    Excel 2007
    Posts
    68

    How can i edit the data at run time

    Hi All

    In my project i have 5 columns

    Name of the Student Marks1 Mark2 Mark3 Total Comment

    x 49 59 69 535 Work hard
    y 53 53 53 346 Not bar



    z 35 53 53 292 Meet Hod


    In List Box1 I have to display the name who secured more than 400 marks. and in RefEdit1 i have to display the comment.

    When i select the name of the student the particular comment display in refedit1.

    When i update the commment it should updated in the particular rown. How can i do it.


    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: How can i edit the data at run time

    Vanakkam karthisucc9,

    unfortunately you don't write if the Listbox1 should be based in a Userform, or directly in the worksheet. Would you expect to see all studends with a total >400 or just the first?

    I would suggest that you upload a sample file, idealy with the Userform already created. I am sure it will be far easier for the forum members to provide you with the required code, once we have a better idea of what you really need.

    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

+ Reply to Thread

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