将用户表单直接放在excel表上 [英] Put a user form directly on the excel sheet

问题描述

我们可以添加内置的控件以及活动的x控件。我不明白为什么我们不能在同一个工作簿中添加用户表单。

谢谢

解决方案

不，我不认为这是可能的。

Userforms只是容纳您的ActiveX控件的容器。电子表格也是ActiveX控件容器，所以我不知道在容器中有容器的好处是什么。

您可以轻松地将一组单元格看起来像一个用户窗体，并将ActiveX控件放在该范围内。这将模拟嵌入在电子表格中的用户界面。你会丢失用户级别的事件，可能还有一些其他的事情。但是，如果你想要这些东西，你可能只需要使用一个用户窗体。

如果你想要做的事情，我失踪了，让我知道。 p>

Is there any way to insert a user form directly on the excel sheet?

We can add the build-in controls as well as active x controls. I don't see why we cannot add user forms within the same workbook.

Thanks

解决方案

No, I don't think it's possible.

Userforms are merely containers to hold your ActiveX controls. Spreadsheets are also ActiveX control containers, so I'm not sure what the benefit of having a container in a container would be.

You could easily color a group of cells to look like a userform and place ActiveX controls within that range. That would simulate a userform embedded on a spreadsheet. You'd be missing userform level events and probably a few other things. But if you wanted those things, you'd probably just use a userform.

If there's something you want to do that I'm missing, let me know.

这篇关于将用户表单直接放在excel表上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！