+ Reply to Thread
Results 1 to 18 of 18

Need VBA Code to listout Emp Name and Location from value of combobox team

  1. #1
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Need VBA Code to listout Emp Name and Location from value of combobox team

    Dear experts

    I have combobox in Main_page i want list out unique values of rawdata Column C:C Team

    if i pick team "Operations" and click Mark Attedence, userform1 will popup in listbox according to operation's emp name and Locate will shown up data with multiple selection of pick x option


    there is 13 userform for 13 team each team under there employee with location(onsite/offsite) list

    find the sheet setting explain for userforms


    find the attachment & image file is my expect result in uesrform listbox
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by johnmacpro; 12-09-2022 at 08:23 AM. Reason: file missing

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team


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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    @Marc L, strange these two guys appear to be working on the same project, similarity is uncanny, they must be 'brothers'.
    Torachan,

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

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Need VBA Code to listout Emp Name and Location from value of combobox team


    Hi Torachan,

    like some student homework …

  5. #5
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    i am also impressed by same thread, so i copied

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    @johnmacpro (aka 'flatterer') - I will look at this in the next day or so.
    first comments - get rid of 'Main Page' - do not mix on-sheet collection with structured VBA UserForms - from a brief look the whole lot can be dealt with on one UserForm cutting any coding down by 90% - more efficiency - more speed.

  7. #7
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    i have question, i learn ask question in forum by other forum question and answer only, i make easy my job from download others file or code connect to my requriement. is it against forum rules?
    (aka 'flatterer') what does mean? english is not first language

  8. #8
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    Any experts help on this tread?

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    patience, some of us on the other side of the world need to sleep.

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    Give the attached file a try - to enter new persons first press 'CLEAR' - enter data and press 'ADD' - to update or delete first enter ID then press enter - rest should be intuative.
    when you are satisfied then we can progress onto getting reports.
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    Thanks alot sir, always greateful to you, you are a genius ,Your genial mind would have analysed this problem and found a solution in different way, i am very ashamed myself, thinking like pad lock horse run on track blindly just copy and paste from other file and code.
    I am 100% happy with this output!! Im statisfied sir,
    would u mind getting report at backup with this file format, more over i want listout B&D column in listbox Name&location.
    I am happy whatever you make changes it would be master piece.

    Thanks and regards to u
    Attached Files Attached Files
    Last edited by johnmacpro; 12-12-2022 at 06:31 AM.

  12. #12
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    HI boss when u free have a look my thread waiting for ur reply

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    have you made any attempt yourself - have a go - show some initiative - then upload then we can help you - better to try and fail than never try at all. (I know it is easier to wear out someone else brain)

  14. #14
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    HI boss i tried to connect with sheetname instead of tbl1 with more line of changes i am not understood logic operators and declaration of var,ref, to be frank i am literally at kinder garden, writing basic environment code section. like copy and paste sheet to sheet , cell to cell but surely i learn soon

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    one report on page3
    Attached Files Attached Files

  16. #16
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    Hi boss thanks for code, i have small concern on report keep changing, i want report update at backup file report.sheet at once, if we do second time updation it popup msg ,attedence already marked for team member. Report tracker for team update for everyday morning only once.

    it will be more help ful for find people onshre offshore if show list in listbox(A&B include D:D row
    becoz logic is one team lead handle onshore and offshore also ,some team lead only offshore i want list out D:D too

    at last command button of present of onshore/offshore validate particular pickup depends rest or all present

    becoz logic is one team lead handle onshore and offshore also ,some team lead only offshore i want list out D:D too

    sorry for annoying u boss for make you tired with these exercise. help me out once at last.

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

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    I have read your post half a dozen times and I am totally bewildered, you are going to have to explain in simpler terms as I have not got a clue what you want.

  18. #18
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: Need VBA Code to listout Emp Name and Location from value of combobox team

    sorry boss there are alot of seeker in forum thanks for effort spend your time on thread!! grateful to you

+ 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] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  2. VBA Code to SaveAs file in one location, and backup to another location
    By honger in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2014, 10:57 PM
  3. Code that works in one location but not another location. (AdvancedFilter excel function)
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 02:18 PM
  4. Replies: 2
    Last Post: 12-06-2012, 06:02 PM
  5. Combobox: How to determine the location of the selected item if combobox has rowsource
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2012, 03:24 PM
  6. Update RowSource location for ComboBox
    By NahRoots in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2012, 01:57 PM
  7. Combobox/text location on screen
    By ozhunter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2011, 10:04 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