Link to home
Start Free TrialLog in
Avatar of Svgmassive
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
ASKER CERTIFIED SOLUTION
Avatar of Kimputer
Kimputer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Svgmassive
Svgmassive

ASKER

kimputer not exactly what i am looking for
In that case, more details would be nice. As you can see, all selected items populate the cells you mentioned in one go.
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