Range of Cells to populate in a text box on a userform
 

I have scoured the internet and help for answers to this one.
Is there a way to have a range of cells populate a textbox on a
userform when I click a commandbutton?
So far I have been only able to: make a text value entered in the macro
code of the commandbutton populate into the text box. Another way made
the text populate into the worksheet cells that I wanted to import
from.
I am wanting to use protected worksheets(not protected from me) to edit
information, and have the users see that information and any changes I
make, via the userform and command buttons. Anyone have ideas on how
to program macros to do this?
Thank you for your time hard hard work

Benji


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Range of Cells to populate in a text box on a userform
 

After 2 twos of deep thought here is the answer :

TextBox1.Value = ("")
Sheets("Sheet Name").Select
ActiveSheet.Range("$a$1:$L$61").Copy
TextBox1.Paste
Sheets("Main Page").Select




The results were very pleasing although I need to adjust the
information on the worksheet. This alows me to input the information on
the worksheet and other users can view only this information via a
command button on a userform.

Thanks to all who looked and tried!!

Ben :D


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/