Hi Everyone, I'm new to here and also new to VBA with Excel
here is the scenario
I have a spreadsheet, apologies, still learning the verbiage. I mean, I have a workbook that has four worksheets.
the One worksheet called Search is used to house the button i created called cmd_HarmListA to open the Userform titled UF1_HarmForm
That works as expected
What I can't figure out is how to write the code to get the Harm list to display in the first combo box so that when the Harm is selected it displays the possible matching harms from CHL and FMEA
I need to have three combo boxes one that lists the Harms and two Combo boxes that pulls the Harms from the CHL and FMEA worksheets both using column A
I created a button to execute called cmd_HarmList Result
I've created all these but not fully grasping the code required
Can someone please help me with how this works, I spent over 20 hours going through some VBA courses on udemy but
not grasping what Im missing?
ve tried several code but removed them because I couldn't get them to function
everything is in place except the code to make this work.
Where I get hung up is the data doesnt' display in the comboboxes. Is there a way to get that to pull from the columns or do I need to use the .Addto function but that would be a lot of entries and if thats the case whats the point of having the data in columns.
Bookmarks