Hello, how can I have the data from the workbook with the userform copy to another workbook named something else. What I would like to do as a work around for where I am at is create a file for each user with it's own userform and have their data copy to a master log. I have created the userform and saved workbooks as desk1 and desk2 and have the master log workbook saved as combinedesks. how can I copy the data from desk1 and desk2 into combinedesks? They are all on the same share drive also.
Input data to the userform with code like
and export it with
Please 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.
Thanks, question though, would I need to do this for every textbox, combobox, etc... on the userform.
If you want your user form to interact with a workbook, you have to tell it which workbook.
And every control that did something to that workbook would have to refer to it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks