Re: I've Lost Control !!!
From: Jezebel (dwarves_at_heaven.com.kr)
Date: 10/22/04
- Next message: Cris Sapher: "Re: How to add an icon in a user form (next to caption text)?"
- Previous message: Geoff: "I've Lost Control !!!"
- In reply to: Geoff: "I've Lost Control !!!"
- Next in thread: Geoff: "Re: I've Lost Control !!!"
- Reply: Geoff: "Re: I've Lost Control !!!"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 22 Oct 2004 15:44:20 +1000
You've possibly moved them way off view, like with negative top and left
values. You can find them again this way:
Display the form in VBA. Display the Properties dialog (press F4). In the
drop-down at the top of the dialog, select one of the 'missing' controls
such as Frame2.
Set Top and Left to 0 to move the control back to visible territory.
"Geoff" <geoff@nospam.com> wrote in message
news:Ofiwul7tEHA.3088@tk2msftngp13.phx.gbl...
> Hi!
>
> I think I wasn't quite careful enough with the mouse (boy it's
> sensitive!) and ended up creating a duplicate set of controls on my
> user form. I know they exist because they're listed in the VBA editor
> drop-down list. I want to delete them but I cannot locate them
> visually on screen in design mode. I've moved all controls I can see
> out of the way, in case the offending controls are hiding, but no luck
> there!
>
> I've discovered that Label1 is in Frame2, with the following code:
>
> Debug.Print UserForm1.Label1.Parent.Name
>
> But I cannot locate Frame2.
>
> Q1 - How can I locate and delete controls when I can't see them in
> design mode?
>
> Q2 - Can I open a form in design mode using VBA and permanently delete
> controls that way?
>
> TIA
> Geoff
>
>
>
- Next message: Cris Sapher: "Re: How to add an icon in a user form (next to caption text)?"
- Previous message: Geoff: "I've Lost Control !!!"
- In reply to: Geoff: "I've Lost Control !!!"
- Next in thread: Geoff: "Re: I've Lost Control !!!"
- Reply: Geoff: "Re: I've Lost Control !!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
