Form in Design View. Lost controls

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
2,072
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
Hi, I'm creating a Form with a Frame on a Text box and various controls on the Frame.

I clicked on one of these controls to get its Properties and the Frame+all controls disappeared. All I can get at now is the text box.
How can I restore/see the Frame+ controls again? It's as if they're all under the text box, but if I reduce it's size all I see is the Form

Thanks
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Can you still select the controls in the dropdown at the top of the Properties Window?
 
Upvote 0
Yes, but only if I click the text box first.

It's like I need to select the Frame, but can't because the text box is covering it.

However I've just narrowed the text box and can see Frame & its Controls again now. But how do I keep the Frame on top (or the text box behind) ?
 
Upvote 0
I'm sorry but I'm really not understanding the set up here.

Where exactly are the textbox, frame and the other controls located?

Is the textbox in the frame?
 
Upvote 0
The textbox and Frame were almost the same size, the idea being the Frame sat inside the text box, so you could just see it's borders.
It worked pretty well and is an idea I ported over from Excel 2003 (to 2007).
It was just a visual thing and after the hassles I think I'll bin the Text box to avoid having the problem again. LOL nearly the whole day wasted !!
 
Upvote 0
Could you not use the SpecialEffect property of the textbox to get the visual effect you want?
 
Upvote 0
Ah, what a splendid idea that is ;) (You mean of the Frame)
I didn't know it had one!
 
Upvote 0
Well I did actually mean the textbox, but if the frame works for you...:)
 
Upvote 0

Forum statistics

Threads
1,223,871
Messages
6,175,099
Members
452,612
Latest member
MESTeacher

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top