Svgmassive
asked on
populate cells from combo box
I have a combo box that the user selects a value, once the value is select i would like to populate the cells from the the combo box columns i am currently using a loop,but i would to accomplished this in one pass.
let's say range("ao17: at17") must be populated from cbobox column 1 to 6
let's say range("ao17: at17") must be populated from cbobox column 1 to 6
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In that case, more details would be nice. As you can see, all selected items populate the cells you mentioned in one go.
ASKER
can this be done in one line of code? i would rather use a loop which i am currently using if this can't be accomplished
Then the answer is no
ASKER