Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a control to a User Form | Excel Programming | |||
user form & control properties | Excel Programming | |||
user form and frame control | Excel Programming | |||
Spreadsheet Control on User Form | Excel Programming | |||
Control Order on User Form | Excel Programming |