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

  • Thread starter Thread starter BenjiHarshbarge
  • Start date Start date
B

BenjiHarshbarge

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
 
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
 
Back
Top