+ Reply to Thread
Results 1 to 3 of 3

New to Forms-How do I find a missing control?

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    New to Forms-How do I find a missing control?

    I was making changes to a form. I accidentally let go of a checkbox while dragging it across the form and it instantly disappeared! How do I find it again?



    What I have tried so far:

    I have tried extending the form to one side (to provide some free space) and then dragging all the labels, checkboxs, frames etc. over in case the checkbox was hidden behind one of these controls. Didn't work.

    I have tried tabbing through the controls and checking the Properties window while I do it. The missing checkbox never came up.

    I have checked whether the control still exists. It does. (I added another checkbox and tried to set its name to that of the missing control, received ambigious name error)
    Last edited by mc84excel; 06-06-2013 at 08:34 PM. Reason: Update to include what else I have tried
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    198

    Re: New to Forms-How do I find a missing control?

    In my version of Excel, you can see all the control names in the Properties
    drop-down list. When you see the name of the one that may be hidden behind
    another control, select the name, then change to Left and Top positions to
    something that will move the control and allow you to see it again.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: New to Forms-How do I find a missing control?

    It worked! (I never would have thought of that solution) Thank you +1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1