Hi!
Is there a way to copy and paste combo box form controls keeping the input range static but the cell link relative in Excel 2013?
I've tried usual methods, but all seem to paste a combo box with absolute ranges and cell links.
I have to create many combo Boxes then have copy them with relative cells links.
Link to a similar solved thread (it used Active X controls instead of form control) is given.
https://www.excelforum.com/excel-for...cell-link.html
I'm not a VBA user/ programmer and hence cant modify the solution in the above link to my specific requirement. Sample scenario is enclosed in a simplified manner.
Any help will be appreciated.
Bookmarks