I have created a userform and understand how to populate data from a single
textbox/combobox to an 'ActiveCell', however, can't figure out how to
populate data from the single textbox/combobox to an entire area that I've
selected/highlighted.
Please help me.........

Much Appreciated.

What do you want to do?
1. Put the selected value of the list/combobox in every cell of the
selected range?
or
2. Distribute the entire contents of the list/combobox across the cells of
the selected range?
and
3. By single list/combobox, do you mean one column single select,
multicolumn single select or one control multcolumn?

"Alpineman2" wrote:

I have created a userform and understand how to populate data from a single
textbox/combobox to an 'ActiveCell', however, can't figure out how to
populate data from the single textbox/combobox to an entire area that I've
selected/highlighted.
Please help me.........

Much Appreciated.

I would like to:
-Put the selected value of the list/combobox in every cell of the
selected range.

-By single textbox/combobox I mean one control to one column and/or multi
column.

Thank you, JLGWhiz



"JLGWhiz" wrote:

What do you want to do?
1. Put the selected value of the list/combobox in every cell of the
selected range?
or
2. Distribute the entire contents of the list/combobox across the cells of
the selected range?
and
3. By single list/combobox, do you mean one column single select,
multicolumn single select or one control multcolumn?

"Alpineman2" wrote:

I have created a userform and understand how to populate data from a single
textbox/combobox to an 'ActiveCell', however, can't figure out how to
populate data from the single textbox/combobox to an entire area that I've
selected/highlighted.
Please help me.........

Much Appreciated.