Jeffrey Lebowski
Member
Hi:
I have drafted up a sample of my problem. Here is the link.
https://www.dropbox.com/s/fg50jrb7dbg79ur/txtbox userform.xlsm
As you can see my table has a ton of combo boxes. For the sake of my question we are only concerned with the combo boxes in the 'Notes' rows (5, 9, 13, 17, 21). The combobox in "B5" is tied to code so that when Yes is selected, it prompts a userform that allows text to be entered. When the userform is filled and OK button is hit, the textbox info is copied into the 'Notes' sheet table (cell b2).
I want this same process to happen for each of the comboboxes in any of the aforementioned rows when their value is 'yes'. I could figure out how to reuse the same userform, but what I cant understand is how to tell the userform to change the cell it populates based on which combobox triggered the userform.
Let me know if I can provide more detail on the issue. Thanks for helping!
I have drafted up a sample of my problem. Here is the link.
https://www.dropbox.com/s/fg50jrb7dbg79ur/txtbox userform.xlsm
As you can see my table has a ton of combo boxes. For the sake of my question we are only concerned with the combo boxes in the 'Notes' rows (5, 9, 13, 17, 21). The combobox in "B5" is tied to code so that when Yes is selected, it prompts a userform that allows text to be entered. When the userform is filled and OK button is hit, the textbox info is copied into the 'Notes' sheet table (cell b2).
I want this same process to happen for each of the comboboxes in any of the aforementioned rows when their value is 'yes'. I could figure out how to reuse the same userform, but what I cant understand is how to tell the userform to change the cell it populates based on which combobox triggered the userform.
Let me know if I can provide more detail on the issue. Thanks for helping!