frame

Howdy So the project I'm doing has me at a crossroads. The PERFECT candidate for what I'm trying to achieve is a Frame control. It's isolated, scrollable... it's just that in a worksheet they're the devil. Simply trying to add one at runtime throws up odd exceptions and bugs ("Cannot enter...

This message https://www.mrexcel.com/forum/excel-questions/726568-frame-control-activex-option-button.html Showed me how to add the buttons to a frame, which I did easily, What I don't know is how to access the controls on the frame when they are clicked. I experimented and can address them...

Hello, Hope you are well. I have a Userform with a 2100 height. On this Userform is Frame14 with a 2000 height and scrollbar set Vertically to a 1950 height. On Frame14 is 5 different Frames (Frame1, Frame2, ect). What I want to do is if a user clicks the scrollbar the scrollbar should upon...

Is there a way I can loop through all Checkboxes in a Frame on a Userform? All of them are named individually, so not CheckBox1, 2 etc if that makes a difference.

In excel, when you group: rows, data grouping levels are shown in a frame to the left of row numbers columns, data grouping levels are shown in a frame above column letters Is there a way to determine the width of the frame added to excels window?

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I know some about Batch and PS scripting. VBA is very new to me and also not really needed in my line of work. We need to create a product management/inventory sheet to keep...

Hi Thanks for taking the time to look at this and any help given. So I have a contacts userform which has various multipages, frames, tabstrips and textboxes on it and it worked great, the problem I am having is one of the frames which has textboxes in it is now causing the form to crash, if I...

I have a userform with a frame (called Parent_Frame) that takes up the entire userform and the vertical scrollbar is activated. Inside this frame about halfway is 3 menu items each which active another frame underneath of them. Well all works well however right when I click on one of these inner...

I'm strictly trying to improve aesthetics of my userform. I have over 200 labels, checkboxes, textboxes, buttons, etc. I wanted to add a frame control with a darker background to place behind some of the controls at different times (so it doesn't make sense to put the controls within the...

Seeking a simple VBA solution to to determine name of a text label object located on an excel Userform... When this control is placed directly on a raw Userform - it works correctly by returning a message prompt saying "Label19" ..... But when the label is placed within a frame on the form..it...

Hi! So I have come across a problem which can be very annoying. If you have a frame that is say 400 height by 800 width and has vertical scrollbar enabled then within this frame is another frame at position top 1 and left 1 of that frame and is height 700 and width 700. Well since the height of...

I can't find a Frames collection in userform. How to loop through all frames on a UF? Dim c As MSForms.Controls For Each c In UTool.Controls If TypeName(c) = "Frame" Then c.BorderStyle = fmBorderStyleNone End If Next Thanks a lot!

Hi Guys I'm currently using this piece of VBA code give certain labels in my userform a frame. Dim oCtrl As Control For Each oCtrl In Me.Controls If TypeName(oCtrl) = "lbl" Then oCtrl.BorderStyle = 1 End If Next oCtrl I'd like to include if labels caption...

Hello lucky people, I have a Friday Afternoon style question... I have panels, which are linked to frames. Different panels are linked to different frames. I need to find the overall frame heights, by summing all panel heights which are linked to that frame. I had it all working when the...

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...

I need to assign an image to the picture attribute of a label or frame. The only issue is the image has transparency to it. Is there any format that excel supports which allows transparency or a way to make this work?

Hi all I wonder if some one can help me please. I am working on a userform on this form there are 10 frames all hidden until a number is inputted into a textbox so if textbox = 4 then 4 frames become visible, within these frames are textboxes and what the code below is doing is checking these...

I know you can obviously put a frame with controls on a multipage Userform at the time of design, but can I move/show/display/embed a frame with its controls that I saved on another multipage in the same Userform as user makes various selections on the Userform? Currently, I am placing multiple...

Hi, I was curious if there is a way to use a png or some other image file type that allows semi transparency for an image background in a label or frame or some userform tool. Thanks!

On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it. But how can I code some events into the commandbuttons? I can't locate their names and appearance in VBE and elsewhere. The reason of using Frame is to fix the positions of a bunch of already-made...