frame

Hi all. I have the following code to get the selected controls on a userform's designer module. The problem is that some controls are within a frame, in which case the frame itself is added to the collection instead of the selected controls inside it. I expect a similar problem to occur when...

Hi all, MultiColorDragList.xlsm I have been experimentng with the Comctl32 Listbox control in the last few days. The final result looks good BUT there are two major limitations which I should mention upfront beofre getting too excited. 1- ListBoxes can only be added to MODAL UserFoms. 2- No...

i'm using this code to auto add textboxes inside the userform Dim i As IntegerFor i = 1 To Sheets("sheet8").Range("a10000").End(xlUp).Row Set tBox = Controls.Add("forms.textbox.1") With tBox .Name = "textbox" & i .Left = 20 .Height = 20 .Top = i * 20 .Width = 160 .Font.Size = 12 Me("textbox"...

I have this datepicker that I have placed on a frame in order to hide it and show it in various instances. Now I am using the "mouseMove " event from a parent frame to hide or show the datepicker. It responded fine. The only issue here is that when the datepicker is opened, after hiding the...

Not sure if this is even possible, but I have a userform that has a width of 588 when fully viewed. What I'm wondering is when the user opens this I could have the width set at 150. And if in textbox2 they enter a 2 then the width of this frame will expand to 294. If the value entered in...

Once again I bow to the superior knowledge of the group to see if I what i want to do can be done. I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkboxes in the first frame and then select 1 optionbutton...

Good day all, I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 columns. The 40 textboxes on the first column each have a list box. The problem is when I double click on the list box...

Hi all, I try to understand why my code to clear option button does not work. I know how to clear listbox or textbox from userform, code below ListBox2.Clear TextBox1 = "" But from various optionbuttons in frame, it does not work Here I have 2 frames, with 4 option button in the 1st...

Hi, I am curious if there is a way to loop through all control objects in a userform frame or do I have to loop through all objects in the userform and look for that particular frame as a parent? For instance, can I use a for each item in frame type loop? My Current code draws a mistype error...

I need a code for mouse wheel to scroll the scrollbar on a frame. Note: the userform itself is modeless.

Hello experts. I need to generate QR Code with Excel,and I already done it using a vba code that I saw in Youtube, it works very good, but I need to get rid off the frame around the QR code. How can I do this?. Here is the vba code:

Hi Folks, Sometimes re-sizing a Frame on a UserForm will "warp" the font size in some (but not all) lines of Text or in Control captions. I haven't been able to figure out any pattern(s) to this phenomenon—it just makes things look weird, especially if/when using mono-spaced fonts. It doesn't...

I am using the age old loop through the controls ie. For Each cCont1 In Workshop.Frame2.Controls If TypeName(cCont1) = "TextBox" Then etc., etc. My question is "How do I identify the frame that the control resides in?" I have 10...

Hello, I have a chart set up as following... (Chart 1) B C D E F G H I <tbody> ML Frame Chassis 1 Chassis 2 Chassis 3 Chassis 4 Chassis 5 Chassis 6 ML1 Frame 1 1-576...

Hello experts, as I did not find solution anywhere and dont know how to solve it myself, I would like to ask you for help :-( I have sheet (for example sheet1), on that sheet I have Frame(Active X controls), inside this frame is button and I dont know, how to assign macro to this button...

Hello guys, hope somebody can help me :-) I am working now with ActiveX controls and stucked little bit.. on sheet1 I have ActiveX Frame, inside this Frame I have another two frames and inside those frames, I will have textboxes...Do you pls know, how can I identify those textboxes and extract...

So what I have is a userform that have a Combobox that asks what type of operation you are doing (ie Saw, Laser, Mill, Outsource). Each one of these operation has different questions than all of the rest (Saw - Do you need to add extra to the length for cleanup? Laser - Do you need a new...

Hi guys, need some help here. I will like to click on a button that seems to appear on the top frame and once click it will appear on the main frame. So how should I go abt writing it. span class=“btn float_left ” em class=“btnleft” o n c lick=“tocustomerview()" I will click on the button...

Dear Experts, I really need your assistance on this task. Please have a look and thanks in advance. Tasks: 1). To pull current accumulated values in the column(ENDQTYMAIN) from database("RawData") WS to another WS("DASHBOARD") in the column(TURNS) based on criteria which would be STAGE column...

When you have 2 frames in a userform overlapping, how do you control which frame is on top?