+ Reply to Thread
Results 1 to 6 of 6

Problem in listbox

  1. #1
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Angry Problem in listbox

    I have a 2 list box

    listbox1 listing some values

    eg.

    nb1
    nb2
    nb3


    when i select anything on that listbox1. eg.... nb2

    that time i need to populate the similar column values only on listbox2

    plz help me



  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,977

    Re: Problem in listbox

    It is not at all clear what you want in listbox2. What does "populate the similar column values" mean?

    It would be very helpful if you attach a file with sample data showing the result you want.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Problem in listbox

    Hi..Thanks for reply

    Herewith i attach the sample file

    in the alloctor sheet i need a user form

    its need to load staff details list box (getting data from staff details sheet)

    when i entered duty in that user form to purticular person that time allocation sheet that similar person names cell colur need to change yellow

    Actually in my department i have 400 persons work on per day..

    Which person where they work we did't find.

    now we print a page and tick personally... than we put attendance... than we make one month consolidate for monthly salary

    So many salary problem.. please help me guys only two shifts available ... morning 7 to 5.30 pm, eveneing 5.30 Pm to 7A.M
    Attached Files Attached Files
    Last edited by rukman; 01-02-2016 at 05:51 AM.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Problem in listbox

    What is the use of sheet "allocation" ?
    Can you give a detail example and better prepare a new sheet showing how the user form is.
    - Battle without fear gives no glory - Just try

  5. #5
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Problem in listbox

    400 workers in my unit

    everybody should allocate on one permanent place.

    If incase he / she take leave. That time we need a reliever on that place.

    In My allocation software use is..... when the worker is come on morning i put duty. that time on my allocation page similar name cell colur change to yellow.

    that time only i know that place man power ok..... when its not change that time i provide reliever to that place.

    Than this page to i get some information for salary purpose

  6. #6
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Problem in listbox

    https://www.youtube.com/watch?v=ulIraDmhF0o


    i seen in this video... i need this on a user form

    please help
    Attached Files Attached Files

+ 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. [SOLVED] problem with listbox output to another listbox
    By AndyE in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-02-2013, 04:52 AM
  2. [SOLVED] Listbox problem
    By Masun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 10:20 AM
  3. 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
  4. ListBox Problem
    By Jl9r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2008, 03:08 AM
  5. ListBox Problem...
    By collamack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2008, 01:52 PM
  6. listbox problem
    By walid66 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-24-2008, 11:13 AM
  7. [SOLVED] Listbox problem
    By browie in forum Excel General
    Replies: 1
    Last Post: 08-22-2005, 07:05 AM
  8. [SOLVED] Listbox problem
    By browie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2005, 07:05 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