+ Reply to Thread
Results 1 to 2 of 2

Edit worksheet using user form

Hybrid View

Susanmlynn Edit worksheet using user form 12-18-2012, 11:00 AM
Susanmlynn Re: Edit worksheet using user... 01-10-2013, 03:19 PM
  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    4

    Edit worksheet using user form

    Because nobody is perfect, I need a code to edit information previously entered on a user form.

    I created a user form which saves input on a worksheet.

    Information previously input via the form is reviewed by staff by use of a listbox with textboxes displaying the other columns in the selected row. They scroll through the first column of information looking for a row that displays a desired part#, and then the textboxes display the other information in the chosen row.

    Staff do find mistakes and they need to edit this info. Since textboxes are editable, I don't see why this isn't possible.

    I've been very frustrated creating code to save these edits. The furthest I've gotten is to be able to re-write the first cell in the chosen row of the listbox but saving to the cells in the next columns over has escaped me. I've tried with listindex, listcount, listrows...

    P.S. my code is on my home computer - I'm at work - I worked on it all weekend :-(
    Last edited by Susanmlynn; 12-18-2012 at 03:30 PM.

  2. #2
    Registered User
    Join Date
    12-10-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Edit worksheet using user form

    ANSWER -

    For anyone that is interested in an answer to this question, I found a model for this type of user form on the Contextures website. The model form and the instructions to edit and customize the form are on two separate postings so I have pasted both below.

    Model form: http://blog.contextures.com/archives...#comment-43464

    Instructions to customize and edit the form: http://www.contextures.com/exceldata...pdateform.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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