+ Reply to Thread
Results 1 to 3 of 3

Edit ListBox Items

Hybrid View

  1. #1
    Registered User
    Join Date
    07-16-2016
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    2016
    Posts
    22

    Edit ListBox Items

    Hello once again, everyone. Hope you get to me help out once again on this one.

    I'm handling the following issue:

    I have a listbox which is populated upon form activation. Besides, the form has 3 buttons:

    -An ADD button: which pops up a form to register a new entry to the listbox and the excel sheet;
    -A DELETE button: which deletes the selected list item and;
    -An EDIT button: to edit the entries which have already been done.

    What I want to do is: for the edit button to open the "new entry form" with all textboxes filled out with the values found in the sheets. As if I had opened the form right after making the entry and not unloading it. After that, the new determined values are not to generate a new entry, but substitute the old version.

    Any ideas?
    Thank you all in advance!

    Cheers

    (Crossposted at http://www.mrexcel.com/forum/excel-q...ml#post4581303)

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,789

    Re: Edit ListBox Items

    "As if I had opened the form right after making the entry and not unloading it." Don't unload it. Use
    Me.Hide
    instead of
    Unload
    If that misses your point, then it would help to attach your file (which you cannot do on MrExcel).

    By the way thanks for noting your cross-post.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-16-2016
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    2016
    Posts
    22

    Re: Edit ListBox Items

    Thanks for the quick reply!

    That would indeed do the job, but then I would always open the last entry, instead of any selected one. I was thinking about the edit button opening the form and me defining each textbox separately using the cells values. Something like Textbox1 value should equal A2. Something like this. However I lack skill to code it...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. is it possible to edit items of a listbox in excel VBA
    By maggie_xio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2015, 05:46 AM
  2. Select & edit items in a listbox in VBA
    By poppy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2014, 04:47 PM
  3. [SOLVED] Auto select items in a Listbox with items from another Listbox
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-22-2013, 04:45 PM
  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. VBA edit listbox items on userform
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 03:51 AM
  6. Edit listbox selected items and save to workbook???
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 08:00 AM

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