+ Reply to Thread
Results 1 to 2 of 2

Select a name that has been passed from one Userform to a listbox in another uform

  1. #1
    Registered User
    Join Date
    09-29-2021
    Location
    Nowhere, USA
    MS-Off Ver
    14
    Posts
    3

    Select a name that has been passed from one Userform to a listbox in another uform

    I am attempting to set up an Excel program that keeps up with member contributions to an organization, among other data.

    I have a list of members which I use to populate a listbox in userform1. When we have a new member, there is a checkbox that can be clicked on which brings up userform2.

    In userform2, the name and other information can be input. Once the okCommand button in userform2 is clicked, userform2 unloads and the listbox in userform1 is updated with the new member name.

    Even though the new member name shows up highlighted in the userform1 listbox, the name is not recognized as the listbox value unless I click on it.

    Is there a way in which the name can be recognized without having to take an extra step to click on the name? (Such a small thing to drive someone nutty.) Thanks.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,303

    Re: Select a name that has been passed from one Userform to a listbox in another uform

    see big yellow banner - far easier to give definitive solution using your actual workbook.
    de-sensitise the data (10 typical rows should be sufficient) it is the coding that is relevant to the type of solution offered.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Select UserForm ListBox value from matching value
    By peejayjay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2017, 06:29 AM
  2. [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
  3. Is it possible to pre-select an item in a ListBox in a Userform?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2014, 02:14 PM
  4. select name in listbox in userform and view details
    By simeonmein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 02:02 PM
  5. Select UserForm ListBox Value For Closed WB Input
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2011, 06:02 PM
  6. Select Cells from Listbox on Userform
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-24-2011, 08:35 AM
  7. UserForm;Listbox Select Show Picture
    By samsara in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2009, 09:48 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