Hello all,
First I wish to thank Mehmetcik for all his help and patience with me as I familiarize myself with requests, forums and vba in excel with Userforms.
With Mehmetcik's help I updated his great code given and made it more detailed to my needs within the userform
My problem now is I have a few comboboxes and listbox and need to populate the listbox with with data that associates directly to the combobox numer chosen. I am also looking at when the number chosen from the combobox once it fills the listbox I am trying to see if it can pull the data for all agents that have that number beside their name and place in the next combobox.
combobox1 is named cbMU and that drives results in listbox named lbMSN with the skills for that MU. Plus the cbMU needs to call the data for all agents into the combobox named cbData.
All data is pulled from GtoICheck and the Audit date Tracker is for tracking from the lower section you may see when opening and viewing the userform
All agent names are in col A
the MU they are placed in is in col C
skill name each agent has is col E
G skill col F and IX skill col G and finally name check is col H
Column R, S, T have the MU, Skill name, and level
example: cbMU drop down chosen say # 100 from list then any agent in 100 from range A;H show in cbData (have to not include blank columns in cbData but not delete in worksheet) and also populate lbMSN with the skill names and levels only (not the MU #) for that particular number chosen.
I tried adopting a few codes from sites and forums and none seem to fit what I am looking for considering the columns and rows are somewhat spaced and unorganized but they have to stay that way as I removed confidential info from the workbook so it becomes usable for assistance.
I also have AE:BB which has the MU number and skills under each MU in attempts to try and make it work but to no avail.
Here is what I managed to get which fills the lbMSN but even the results are not correct
the remaining UserForm code I did not include as it relates to a previous problem that as mentioned I had help for and adapted the code to suit my requirements.
Any help or guidance is greatly appreciated as I continue to learn and develop as I find building things like a userform and applying vba code is exciting and yet a hard challenge that I like.
Bookmarks