+ Reply to Thread
Results 1 to 6 of 6

Listbox need to generate and save

  1. #1
    Registered User
    Join Date
    08-21-2023
    Location
    Madurai india
    MS-Off Ver
    2016
    Posts
    8

    Listbox need to generate and save

    Good day Gurus,

    Please Help me to complete the issue

    I attached excel sheet. in Team user form i want to select 1 Team and i want to Select Member1 , Member 2 and Member 3 then press Team Ok button means. Listbox2 populate the Team no and Member1 and member 2 and member 3 on seperate column at the same time listbox 5, 6, 7 that selected values are need to remove. when i complete the all teams then i press submit button that whole data will be save on Sheet " Team Details"..

    Please Help Me
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,919

    Re: Listbox need to generate and save

    1. Update your forum profile - there is no Excel 2017.
    2. Go back and mark your previous thread as solved - I have left instructions there for you.

    Do not ignore these instructions.

    Thank you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    577

    Re: Listbox need to generate and save

    OffTop!
    Quote Originally Posted by AliGW View Post
    there is no Excel 2017
    Everything is possible there, but they posed as AI to a thousand programmers.
    NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
    You can say "Thanks" in your thread to everyone who offered to help you.
    You can also reward them by clicking * "Add Reputation" under their username on the left.
    With Regards, MikeVol.

  4. #4
    Valued Forum Contributor
    Join Date
    05-02-2013
    Location
    Poland
    MS-Off Ver
    Excel 2013
    Posts
    368

    Re: Listbox need to generate and save

    There is no submit buton. I am providing the code for the Save buton

    code in module Team form
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-21-2023
    Location
    Madurai india
    MS-Off Ver
    2016
    Posts
    8

    Re: Listbox need to generate and save

    Good day Gurus,

    Please Help me to complete the issue

    I attached excel sheet.

    in "Team" userform

    Listbox2 first need to populate the value from "Team Details" sheet 4 columns "A to D".

    If the sheet Values are available means its auto populate the Listbox2 4 columns. else its empty.

    If any value populated on Listbox2. Same time its need to remove from Listbox1 ,5,6,7 .


    Please Help Me
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    577

    Re: Listbox need to generate and save

    Hello @rukman1kani. Full code for UserForm Team:
    Please Login or Register  to view this content.
    Good luck.

+ 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. Replies: 0
    Last Post: 08-27-2015, 09:44 PM
  2. Generate and Save Workbooks automatically
    By sammytsunami in forum Excel General
    Replies: 0
    Last Post: 06-05-2015, 08:28 PM
  3. How to generate a new form according to items in listbox
    By lavender57_1014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2014, 03:00 PM
  4. Generate filename and save in folder
    By ajasons in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2012, 04:59 PM
  5. [SOLVED] UserForm contains optionbuttons that generate listbox to make selection
    By jbeeball in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2012, 09:34 PM
  6. Generate a listbox
    By patele in forum Excel General
    Replies: 4
    Last Post: 10-06-2008, 06:05 AM
  7. Listbox to generate 2nd Listbox
    By SirLoin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2006, 04:20 AM

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