UserForm_Initialize() and set up the worksheets
Hi,
What is the best way set up the sheets when working with forms?
I don't like to set up the sheets all the time..there must be an easier way right?
Please Login or Register to view this content.Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mreFF; 07-06-2014 at 12:48 PM.
When reading or adding data to it, you allways have to use Worksheets("Sheet2").Select ?
No, you can change cell values without activating the sheetWhen reading or adding data to it, you allways have to use Worksheets("Sheet2").Select ?
can be done (faster, more reliably and easier) byPlease Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks