将用户表单复制到另一个工作簿 [英] Copy userform to another workbook

问题描述

我一直在寻找这个问题的答案，但是找不到任何与我所寻找的内容完全匹配的东西，如果有人知道答案或可以将我指向可以回答这个问题的方向，非常感谢.

我一直在与我讨论建立一个将数据输入到工作簿并成功建立解决方案的解决方案，但是需要将其添加到工作簿中的工作是一个非常活跃的工具，并且会不断用新的/更改过的数据进行更新，因此我不得不将其构建在工作簿的副本中，现在需要将其添加到活动工作簿中.我知道一个简单的方法是简单地从活动工作簿中获取数据并将其添加到我的版本中，然后使我的版本成为活动书，但是这将是一项相当大的工作，我只能将工作簿脱机使用〜5分钟，所以我想到了更简单的方法是将我的代码和用户表单复制到活动电子表格中.该代码很容易复制和粘贴，但是我找不到将用户表单(格式和全部)复制到工作簿中的方法，有没有办法将其导出然后导入到实时工作簿中?>

我希望这是清楚且易于理解的，如果需要澄清任何内容，请告诉我.

解决方案

您可以打开两个Excel工作表的代码编辑器.现在，将用户窗体从一个Excel拖放到另一个Excel.谢谢

I've had a look for an answer to this question but can't find anything that matches exactly what I'm looking for, if someone has the answer or can point me in the direction of a question which answers this, it would be much appreciated.

I've been talked with building a solution to enter data into a workbook and have successfully built it, however the workbook it need to be added to is a very active tool and is constantly being updated with new/changed data, so I have had to build it in a copy of the workbook and now need to add it into the active workbook. I know an easy way would be to simply grab the data out of the active workbook and add it into my version and then make my version the active book, however this would be a fairly large undertaking and I can only take the workbook offline for ~5 minutes so I figured the easier way would be to copy my code and userform into the active spreadsheet. The code is easy enough to copy and paste in, but I can't find a way to copy the userform (formatting and all) into the workbook, is there a way to export it and then import it into the live workbook?

I hope this is clear and easy to understand, please let me know if I need to clarify anything.

解决方案

You can open code editor for both Excel sheets. Now drag and drop userform from one Excel to another Excel. Thanks

这篇关于将用户表单复制到另一个工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！