controls

Hi there, I have created a sheet with pivot charts that I want to be locked in place, but have their filter controls remain useable. When I protect the sheet though and check 'Use PivotTable & PivotChart', the pivot chart controls are locked. Can someone help? Pete

In order to have a variable visible to all controls in a particular form, does it need to be global? Is there a way to declare a variable to have the scope of all procedures triggered by controls in a from, or would you need to put all the code for the subroutines in a module, with a module...

I m trying to write a code that will look in worksheet "Sox Controls 2018" for a value "Nov1" in Column C (The heading in column starts in C3) and copy over data that's in columns D, F, H, J, P, Q, R, I to a new worksheet that is called "Nov" starting in cell A2. Here is what have so far...

Hi All, I'm just wondering if anybody has ever used two sliders to control one cells value? I know you can link both sliders to the value cell and they will mimic each other but has anybody used VBA, so when you move one slider the value snaps to that value and when you use the other one...

My spreadsheet is getting too cluttered with buttons, menus, text boxes, etc. Is it possible to create a custom popup menu that contains multiple form/ActiveX controls and appears when the user clicks a button on the spreadsheet? I found this basic tutorial here...

As the title states, I have a datepicker and monthview control question. Since I didn't have these controls originally under the Additional Controls selection. I found out how to install the .ocx file that will allow these controls to be added to the Additional Controls selection. So my question...

I am experimenting with programming the ribbon and I want to add at runtime two new commandbar controls to the QAT namely the FileNewDefault and the Spelling controls. The code below generates the xml string and writes the xml string to the Excel.OfficeUI file. However the controls do not load...

Hi I have Form Controls in my sheet like Checkbox, Options buttons etc. I want to clear the sheet from everything including the form controls. I used this code workbooks(1).worksheets(1).cells.clearcontents But that did not clear Form Controls! Any help please. Thanks

I have 2 shapes, stacked (Rectangle 1 and 2). I have these stacked over 2 activeX controls (Labels) so that when I mouse over the group, Rectangle 2 appears/disappears. The labels are both ordered to the back and transparent. I want to take this a step further and also be able to click on...

Hi What is the difference between Form Controls and Activex Control? Why we have both? Thank you very much.

Hi All you Excel Guru's I need a little help. I am using four combo boxes from the Data Ribbon (Controls - Insert - Format Controls Combo Box (From Control). I would like to set it up that when the 1st combobox changes its selection that the other three reset. The problem is I am trying to...

I have six collections of auto generated user form controls Dim MainLabels As Collection Dim Metric1 As Collection Dim Metric2 As Collection Dim Metric3 As Collection Dim Metric4 As Collection Dim Metric5 As Collection And I know I can add a control with this type of code: MainLabels.Add...

My Excel Workbook has macro, a few buttons, checkboxes on it. After recently patched in April 2018, some how all form controls was duplicated with same Name but different msoType. One is type 1 (invisible) and the other is type 8 (visible). So when I click any button or checkbox that try to set...

Hi All I did check this thread related to my question here.. (https://www.mrexcel.com/forum/excel-questions/45786-if-clause-vba-look-checkbox-if-its-checked-not-3.html) I have tried the below option I have tried and also tried few other things mentioned in the above thread, nothing seem to...

Hi, I am working on the excel project where I my client wants to run macro on pre existing commands of Excel... So I am using UI editor to execute that task and my xml code working on buttons controls not in (toggleButton, checkBox, comboBox, splitButton, dropDown) controls, This is my xml code...

Already know how to do this by using the user form name Example of a user form named u1: Set LAB = u1.Controls.Add("Forms.Label.1") I know how to create controls the above way, on demand dynamically (by directly referencing the user form name) I'm trying to add controls dynamically, without...

First of all let me state that my coding ability is very limited. I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1. What I want to due is create a macro to calculate the mass rate of change (i.e. pounds...

Hi I apologise if this is a remarkably silly question. All I want to do is to use the auto-generated data entry form as a basic form that I can modify by going into the normal vba window. In other words, I want to save the data-entry form that can be created automatically from a...

Hi I'm trying to add a control (ListBox) to a Tabstrip. I can add a control to a Frame but using the same technique I thought that I had it sussed. Apparently not. Set Cmd = Frame1.Controls.Add("Forms.CommandButton.1", "cmd1") Cmd.Left = 30 Cmd.Top = 70 Lbl.BackColor...

Hi - I am very new to the world of VBA and am hoping to get help with the scenario below. I have a workbook with over 6 sheets, 4 of which can be printed by the user. One of sheets is a "form" sheet, one is a "controls" sheet. I want to make it so the user can select which of the pages to print...