2 Frame questions on UserForm

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
1)I put a frame in my userform and when I "show" the userform Frame1 appears in the border. Isn't there any way to have the border without the name of frame in the border?

2) Am I correct in assuming that the frame does nothing more than give asthetic appeal to the userform. In other words the controls inside the frame do not gain any functionality by virtue of their being inside the frame?

Gene, "The Mortgage Man", Klein
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Hi, Gene,
1. yes, just click in the frame (being in VBEditor) select the name and delete it
2. mainly esthetic reasons but some code can differ slightly

example
Code:
Private Sub TextBox11_Enter()
MsgBox ActiveControl.Name
'or when on a frame MsgBox ActiveControl.ActiveControl.Name
End Sub
when you enter a textbox on a frame, the activecontrol is the frame !!

hope this helps
kind regards,
Erik
 
Upvote 0
Unless I misunderstood you, that didn't work. In the VBeditor, when I click on it I can only click on the entire frame, not the words Frame1. Hitting delete just deletes the entire frame. (Thank G-d for undo!). I also tried getting rid of the name in the properties section, but Excel gave me an error when I took away the entire name.

Gene, "The Mortgage Man"
 
Upvote 0
I figured it out. I went to the caption section in properties, not the name and just deleted that. Excel wasn't bothered by that at all.

Gene, "The Mortgage Man", Klein
 
Upvote 0
sorry, Gene
bad answer of mine :oops:
(this time didn't check my response before posting)
it's the same logic as for the userformcaption which you can't eighter select to change
ADVANTAGE:
as you found it yourself, you will remember it for ever :-)
best regards,
Erik
 
Upvote 0

Forum statistics

Threads
1,223,495
Messages
6,172,624
Members
452,466
Latest member
Lynlindsay

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