Results 1 to 4 of 4

Update sheet data when editing ListBox items

Threaded View

onmyway Update sheet data when... 03-01-2015, 12:20 PM
jaslake Re: Update sheet data when... 03-01-2015, 01:26 PM
onmyway Re: Update sheet data when... 03-01-2015, 02:10 PM
jaslake Re: Update sheet data when... 03-01-2015, 02:16 PM
  1. #1
    Forum Contributor onmyway's Avatar
    Join Date
    09-03-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    386

    Update sheet data when editing ListBox items

    Hi all,

    I need some help.

    How can I update my sheet data when I update and edit my ListBox items?

    Detail:
    I have a simple userForm (Admin) that has a ListBox that lists the items one creates.

    I have an Edit Line and Update Line button I would like to use for editing existing lines.
    1. Select ListBox line
    2. Click on Edit Line (this populates my 2 txtBoxes)
    3. Click on Update Line (this updates the line in my ListBox)


    How can I have these changes save to, and edit my original lines in my sheet?

    i have attached a sample workbook.

    Thanks all!
    Attached Files Attached Files
    Last edited by onmyway; 03-01-2015 at 02:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. update value and edit items already update on sheet by userform
    By tjxc32m in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-08-2013, 10:13 AM
  2. Editing listbox items in Dblclick event freezes Excel unless mouse moves over listbox
    By muneebmansoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 02:21 PM
  3. Editing cell from selected items in listbox
    By Feloni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 08:01 AM
  4. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  5. Using a Form to update line items on Data sheet.
    By 0255AM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2010, 01:52 PM

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