如何找到丢失的用户窗体控件 [英] How to find lost userform control

问题描述

我有一个带有一堆框架的用户窗体.我不小心将一个复选框放到了其中一个框架中，现在无处可寻.它仍然存在，因为我可以用代码设置它的值，但是看不到它.我尝试扩展框架并移动框架中的内容(以防它落后于其中一个控件).如何将其拉出?

I have a userform with a bunch of frames. I accidentally dropped a checkbox into one of those frames and it is now nowhere to be found. It still exists, because I'm able to set the value of it with the code, but I can't see it. I tried expanding the frame and also moving the things in the frame (in case it went behind one of those controls). How can I pull it back out?

推荐答案

这将告诉您复选框在框架中的位置:

This will tell you the position of the checkbox within the frame:

Private Sub UserForm_Initialize()

Debug.Print Me.CheckBox1.Left
Debug.Print Me.CheckBox1.Top

End Sub

在那之后，仅是向那个方向扩展框架并抓住失控的孩子"的问题.

After that, it's merely a question of expanding the frame in that direction and grabbing the "runaway child".

这篇关于如何找到丢失的用户窗体控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！