This question likely shows just how new I am to this, but I haven't been able to find the answer here yet after searching.
For clarity: I need a userform to popup when the icon in a given cell in each row is clicked, with multiple options of which more than one can be selected, and the options selected will populate that cell or if that isnt possible or it is much easier a adjacent cell. (the intention is to mimic the functionality of a drop down list but with multiple entries )
Example: a survey report on customers who may have multiple products by same vendor. So each row would have a column "Products Owned" (and the userform would give the options; TV, Stereo, Phone, Camera, etc. etc.)
The user would select say; TV and Phone, and either hit ENTER or have a button that says OK, then the cell "Products Owned" would populate with; (TV, Phone )
I have followed some other examples to building a userform that allows the selection of multiple options, from here
and it looks great.
The only problem is the examples I followed were just for the creation of the userform pulling from my data and allowing for multiple selections... It did not show how to code it to output those selections to a cell. (I'm not sure if an "ok" button would be better or the use of the "Enter" key. either would get me by)
Can anyone help with what the code would be to do this. The complete beginning to end would be great as though I will eventually get up to speed on this, and am actually excited about it... first draft of this worksheet is supposed to be reviewed in a day or less.
Thank you in advance for your help.
Bookmarks