在Excel VBA中为用户提供范围选择工具/实用程序 [英] Provide a range selection tool/utility to the user in Excel VBA

问题描述

我正在Excel 2007 VBA中开发用户表单，并希望为用户提供一个范围选择图标，如下所示：

但是，我还没有找到任何内置的表单设计工具或任何在线工具，最少给我一个想法。

解决方案

这个控件称为 RefEdit

em> control。

要使用它，您必须先将其添加到工具箱窗口中，方法是在工具箱窗口中右键单击并选择其他控件。 的。然后选择 RefEdit.Ctrl 并关闭对话框。

现在，您可以在工具箱中选择它并将其放在表单上。 p>

I am trying to develop a user form in Excel 2007 VBA and want to provide a user with a range selection icon, something like this:

However, I have not been able to find any built-in form design tool or any online tool which provides this or at least gives me an idea. If anyone has any idea about this, I will greatly appreciate their help.

解决方案

This control is called RefEdit control.

To use it, you have to first add it to the toolbox window by right-clicking in the toolbox window and selecting Additional Controls.... Then you select RefEdit.Ctrl and close the dialog.

Now you can select it in the toolbox and place it on your form.

这篇关于在Excel VBA中为用户提供范围选择工具/实用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！