Excel VBA - Userform combox problem

  • Thread starter Thread starter bigern1103
  • Start date Start date
B

bigern1103

My User form has extra combo boxes and text boxes that should have bee
deleted. This is screwing with the Tab Order on the sheet. The extr
boxes are not visible so I do not know how to get rid of them. I
anyone knows, please help. The user form was made from a previousl
made form which I removed
 
The problem is I cannot see the boxes on the form in VBA. By using th
Properties window, I can select them and change the properties, but
cannot delete them. The Visible property is also set to TRUE, so
should see them. At the same time they show up on the tab order. Whe
the user hits Tab, the focus is on some box that they can't see. Thi
creates confusion for the user. Anyone know what is going on
 
Maybe their not visible because the userform is too small.

Can you increase the the size of the userform so you can see more controls?

You may want to try playing with the top and left property (make them 0's) to
see if that helps.

(and make the height and width 10 (say) to make sure the controls are visible.)
 
Thanks. I made the form much bigger but still could not find them.
did find one text box hiding behind another. The other 3 boxes and
labels remain a mystery. To fix my tab problem, I just set thei
Enabled property to FALSE
 
Back
Top