Results 1 to 7 of 7

UserForm and Cell Data to ListBox

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2023
    Location
    NYC
    MS-Off Ver
    365
    Posts
    4

    UserForm and Cell Data to ListBox

    Hello!

    I am creating a UserForm that is used to add a new entry or edit an existing entry in a worksheet. The last tackle is the ListBox. The ListBox contains a number of comment codes, pulled from a table in a different worksheet.

    I assigned a variable to aid in getting the selected data in the UserForm's ListBox (there are actually 3) to the cell in the appropriate column in the worksheet when a new entry is created.

    How do I go about retrieving the data from this cell and select all matching option codes in the ListBox?
    If I go to edit an entry in the table using the UserForm, I want these codes to highlight in the UserForm ListBox so I can make easy changes. Something like this.

    Screenshot 2023-10-31 220327.png

    Thanks!
    Last edited by jcv23; 11-01-2023 at 06:48 PM. Reason: Typo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. resize the listbox & userform based on populated data in listbox
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-03-2022, 09:14 AM
  2. Replies: 1
    Last Post: 04-12-2022, 04:38 PM
  3. [SOLVED] Userform Listbox selected data transferred to a Worksheet cell
    By Tony Hadj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2014, 02:51 AM
  4. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  5. userform listbox
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2013, 11:09 PM
  6. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  7. Display a UserForm based on Data selected in another UserForm's ListBox
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2011, 11:35 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