ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Please HELP me!! (https://www.excelbanter.com/excel-programming/404826-please-help-me.html)

Alpineman2

Please HELP me!!
 
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.

JLGWhiz

Please HELP me!!
 
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.


Alpineman2

Please HELP me!!
 
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.



All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com