Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default Finding elusive control on User Form

When working on the tab order for a frame on a User Form, I found a
Checkbox6. But I don't see it. I cut all the other controls (one by one),
and then put them back, hoping to find it hiding underneath. Nope. So how
do I find and delete this bogus checkbox? (xl 2002)

Don <www.donwiss.com (e-mail link at home page bottom).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Finding elusive control on User Form

Click on your userform in the VBE.
Hit F4 to see the properties for that userform.

There's a dropdown arrow in that properties window where you can choose which
control you want to review.

You may have to select a multipage control to see the controls on each of the
pages.

Don Wiss wrote:

When working on the tab order for a frame on a User Form, I found a
Checkbox6. But I don't see it. I cut all the other controls (one by one),
and then put them back, hoping to find it hiding underneath. Nope. So how
do I find and delete this bogus checkbox? (xl 2002)

Don <www.donwiss.com (e-mail link at home page bottom).


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default Finding elusive control on User Form

On Thu, 03 Aug 2006, Dave Peterson wrote:
Don Wiss wrote:

When working on the tab order for a frame on a User Form, I found a
Checkbox6. But I don't see it. I cut all the other controls (one by one),
and then put them back, hoping to find it hiding underneath. Nope. So how
do I find and delete this bogus checkbox? (xl 2002)


Click on your userform in the VBE.
Hit F4 to see the properties for that userform.

There's a dropdown arrow in that properties window where you can choose which
control you want to review.

You may have to select a multipage control to see the controls on each of the
pages.


Thanks. I wasn't aware of the drop down arrow to see all of the related
controls. In my case this was in a Frame, so I had to look at its controls.

Don <www.donwiss.com (e-mail link at home page bottom).
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a control to a User Form scantor145[_22_] Excel Programming 1 October 17th 05 09:27 PM
user form & control properties Mike Molyneaux Excel Programming 0 April 1st 05 07:41 PM
user form and frame control Gixxer_J_97[_2_] Excel Programming 1 February 11th 05 10:26 PM
Spreadsheet Control on User Form Paul Worthington Excel Programming 0 June 29th 04 03:09 PM
Control Order on User Form AKoodray Excel Programming 4 December 30th 03 09:30 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"