+ Reply to Thread
Results 1 to 7 of 7

Listbox selecting another first item after modification on sheet trough userform

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Listbox selecting another first item after modification on sheet trough userform

    Hello,
    I have a small problem when updating a cell on a sheet trough a list box, and the list box as similar items when doing modifying the list box automatically selects the first item and I don't know how to solve this.
    does anyone as any idea?

    Example on the image if I modify the item KS755001 after that the list box selects the item KS755012.

    here's the code:


    Please Login or Register  to view this content.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Re: Listbox selecting another first item after modification on sheet trough userform

    No one knows?

  3. #3
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59
    Quote Originally Posted by dark_prince69 View Post
    No one knows?
    I stil havent found a solution for my problem, i’Ve been searching for a while but don’t seem to see people with the same problem as mine...comes anyone knows how to fix this?

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Listbox selecting another first item after modification on sheet trough userform

    Pictures may be worth a thousand words, but sample workbooks are a thousand times better.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  5. #5
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Re: Listbox selecting another first item after modification on sheet trough userform

    here you go
    you're right it's easier to help if you see the workbook.
    Attached Files Attached Files

  6. #6
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Listbox selecting another first item after modification on sheet trough userform

    I notice that when I select "blocks" 1, 3 and 4, the individual block flickers. If I put the cursor off all the blocks, all three flicker. What's going on there?

    Which form / sheet is the problem?

    Also, why is the form XLS format when you have Excl 2016?

  7. #7
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Re: Listbox selecting another first item after modification on sheet trough userform

    I will close this thread since i've found a workaround for this bug i encountered, thanks to everyone that help'd me!

+ 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. Listbox on userform population and modification
    By Lsxtrkiller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2017, 03:29 PM
  2. Userform listbox - Getting Sheet row of selected item
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2015, 05:00 AM
  3. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  4. [SOLVED] Listbox move up down entries. problem selecting item just moved up
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2014, 07:39 PM
  5. loop trough a userform listbox
    By GregJG in forum Excel General
    Replies: 2
    Last Post: 01-07-2009, 05:51 AM
  6. Update label caption upon selecting Listbox item
    By munkayboi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2007, 04:55 PM
  7. [SOLVED] Selecting a listbox item event
    By Todd Huttenstine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2005, 04:05 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