Form in Design View. Lost controls

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,835
Office Version
  1. 2019
  2. 2016
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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Yes, Norie. To have the text box "recessed" border style.
 
Upvote 0
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,215,445
Messages
6,124,894
Members
449,194
Latest member
JayEggleton

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