• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA UserForm Find Lost Controls

I'm building a UserForm...slowly. As I was working in design mode, I moved a frame that contained textboxes, a command button, etc. and it disappeared into the abyss. I also discovered that I have a bunch of 'extra' controls I don't need, but also can't find/see on the userform. I've attached a screenshot for a visual.
80636

Before I post on the forum, I try to figure out the solution myself. Here are a couple links to sites that offered up codes. They either didn't work, or I could not download the file with the codes.
How to find lost userform controls
User Form Controls Vanished

I also discovered a trick to see if 'extra stuff' exists in each of the frames (see screenshot).
1. Click on the Frame until the outline is looks like diagonal lines
2. Go to Properties
3. Click on the dropdown to see all of the controls within the frame.

However, I checked all of my frames and none of them contain controls that do not belong there.

Thank you in advance for your help!
80637
 
I figured it out! I found this post: Lost controls from userform. This post 'inspired' me to look deeper by selecting a control and looking at the properties dropdown until the missing frame was listed. I had accidentally moved it to a frame within a frame.
I hope this helps someone else that has experienced this issue.
Thank you!
 
Back
Top