controls

Is there any way to loop through the frames and cycle through the controls within them? I'm not as familar with frames as I thought... I'm trying to verify that data has been entered into my controls before going forward. the loop will highlight the requred controls and exit the code if a...

Anyone have experience using their ActiveX Controls in Excel? I've built a workbook using the standard ActiveX controls available from the developer tab directly in a sheet (Windows 7, Excel '13). I have issues with their behavior when viewed at a different resolution, or in Windows 10. Combo...

I am building a custom menu in VBA. This process pulls data from a SQL DB, which takes some time and a connection for each item in the menu. Now I need to have this same menu on each open Excel workbook so the user has access to it no matter which workbook they are on. The more workbooks that...

This shouldn't be hard, but it's giving me fits. This code is working well and I'm creating a collection of textbox controls so that I can detect changes on the userform (to prompt a user to save their work). I want to EXCLUDE one textbox (that I'm using as a search feature) from the...

Hi, I'm having an issue with my active x control and when I unprotected the sheets and workbook and right clicked to check properties, I see a blank property window. Please help.

I know how to code for controls placed on a sheet, both form controls and ActiveX. And I know how to create and code for a UserForm. But here is where I am having a problem: I have inserted a Microsoft Form 2.0 onto an Excel Sheet. On that form, I have placed a Command Button. I cannot find...

Hi All, i'm trying this all day so now it's time to ask the experts. I think i'm close but not sure.... I have a userform with 6 lines. Each line contain some controls like textboxes, commandbuttons and comboxes. With a press of a button i can create a new line of controls underneath them. All...

Hello all, I have been tinkering about with a userform for the past week but I've come up against a slight problem. The Userform that I have created contains both dynamically created controls and a template. The template controls are all working fine and I have managed to get the userform to...

Hi all, I try to create a treeview in Excel 2010 but I get the following message: "Could not complete the operation due to error 800a9cf1". I don't understand why excel 2010 displays this message when I have created forms with treeview which functioned normally. Thanks for your help...

Hello, So I have 14 labels on a User Form. When the user form is loaded on stage 1 I want labels 1 thru 8 to be visible with text on them. when a command button is hit, i want labels 2 thru 9 to be visible with the text from the previous label to transfer to the next label, so the original text...

I have developed some macros in Excel 2013. When run in Excel 2007 the ActiveX controls go bezerk. I can think of two options: (1) convert to Forms controls. How to do that easily? (but fonts are tiny and no background color) (2) perhaps recreate the ActiveX controls in VBA (not sure though)...

I have several questions here that I was hoping you guys could help me with. 1. I have a user form that captures the response of the user when they click okay and then does some actions in the excel sheet based on the response. What is the difference between writing the code related to the...

Can anyone help? I'm using the following code to create and populate textboxes on a userform: Dim ct As Integer Dim txtB1 As Control Dim lbl1 As Control Dim r As Integer 'Database Row Dim c As Integer 'Database Column Dim t As Integer 'Top Position on screen Dim l As Integer 'Left Position on...

I'm new to using append queries. I found this page MS Access Unbound Forms and VBA which talks about creating a continuous form unbound from the original recordset. I think this is part of what I need. I have a continuous form with the source being "qry_BLT_Update". This is an append query...

Ok so i've been working on this inbetween my day to day job and i still can't work it out! :confused: I'll try and keep it simple: I am trying to populate 3 different answer sets within a Userform Listbox or ComboBox. The answer set displayed is dependant on what is selected on the "Answers"...

Hello Everyone I need help in Creating a same functionality like GridView on Form. the GridView will allow the users to enter Data and Can insert new Row. There is no GridView in Excel so What I want to do is to Create a Group of 10 Textboxes which Will act as a Row. There will also be a Plus(+)...

Hey all. I've written a method to copy a worksheet that contains a couple of command buttons at the top of it. The sheet is copied fine, but the command buttons and a text box at the top of the sheet won't copy. I experimented with adding a dummy sheet and button, and recording copying them. I...

I have an Excel Sheet with 10 Textboxes and I group them Together. The Activate method work fine when I Ungroup them But When I group them the Activate method Generate an error. What I want to do is On keyPress or KeyUp or keyDown event when I enter data in Textbox1 and when I press enter key or...

I have put the Frame Control on Excel Sheet and Add Textboxes and Labels to it . Now I want to Send data to Frame Controls(Textbox) from Excel Sheet By a Click of a Button. What is the Procedure to do it? Thanks in Advance

Hello, Why won't "control()" work inside a moduel which is called uppon from a click action of a button?? Basically this code works fine: (inside a module and the userform button calls this macro) Sub test1() If UserForm1.CommandButton1.Caption = "Unlock" Then...