controls

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

Sub test() Sheets("1PLATE").Range("P25").Copy Sheets("1PLATE").Range("C4:E11").Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns, LookIn:=xlValues).Offset(1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub I am...

Hi All, I have an issue currently with the toolbox for user forms. When I add a new userform in the vba editor and then select the toolbox so I can add some controls, the toolbox appears, however it has no controls visible. Initially the toolbox just showed 2 tabs "page 1" and "page 2" and...

Hi Whilst I am quite familiar with creating a list of controls and properties for a form by using code in the forms code module I cannot find a way of doing this for all forms. If I correct in thinking that the userforms collection only includes loaded forms do I have to load all forms and...

I have a userform (as you might suspect from the title :) ) with several (100s) of textboxes and comboboxes that will be posted to a worksheet. I'm hoping I can loop through all the controls instead of typing out each one. I tried to use this: For i = 1 To 6 ActiveSheet.Range("B" & i +...

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. I created a userform but, I decided to just create the form directly on the worksheet. Is it possible to copy all controls on the form and paste to the worksheet so I won't have to start all over?

Hi I have set up 20+ user forms with approximately 50 controls in each one. When designing the forms, it seemed inefficient to give a unique meaningful name to each and every control, so they are currently named randomnly, i.e CheckBox1 could be beside CheckBox101 but still related to the...

Hello, I am trying to create a form in MS Word that a prospective member can fill out and return and the corresponding data fields can then be deposited in an MS Excel sheet. I am using a mix of ActiveX Controls (Text Box and Check Box) as my form fields. I have done some browsing for solutions...

Hi Experts, I made an add-in and am trying to figure out how to remove the custom controls safely: Private Sub Workbook_AddinInstall() Set cBackupRawControl = Application.CommandBars("Worksheet Menu Bar").Controls.Add With cBackupRawControl .Caption = "Backup Raw Data"...

Hi All I understand that one can embed a Worksheet or selected range from a Worksheet into a userform and that this Control should be available on the Form Controls Toolbox. I cannot seem to find it, does anybody know what it is called? Is it one of th Additional Controls? Thanks HighandWilder

Hi, I have a spreadsheet containing 12 ActiveX drop-down lists and 3 check-boxes. I want to create a macro that selects a certain combination of rows and checks/unchecks. I've tried recording a macro, but it won't register any of my selections in the ActiveX controls. Do you have any suggestions?

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

Hi, I have a custom ribbon with controls that I have tags associated to. I can change visibility of groups and controls by changing the tag property: Call RefreshRibbon(Tag:="MyGroup1") I was wondering if there is a possibility of making the same by not changing the tag property, but directly...

Hi there, I have a few dozen textboxes on a userform, might add a few, might take a few away. Looking to change the backcolor of them all. My first question is: are textboxes counted as controls? So I'm trying to write using the following code - any ideas? Dim ctl As MSForms.Control For...

I have a fairly complex ribbon tab for an application that looks quite good when viewed fullscreen on a 1024x768 display. But as soon as the window size gets smaller than that, all of the groups in the tab collapse to icons that must be clicked to display the controls. The default ribbon tabs...

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

Oftentimes, I confused myself with OLEFormat and ControlFormat. To clarify my understanding, is that OLEFormat must refer to ActiveX Controls while ControlFormat must refer to Form Controls? Sometimes I notice cross-application of them among ActiveX controls and Form Controls. What is the...

I've been having this problem for years, that on pressing, my Form Controls and Active X controls (when used on a sheet, not in a UserForm) resize themselves, to the point that after a few presses, the size of the control is far larger than originally set, the font of the text increases as well...

For several years I have used the following code to disable/enable commandbar controls, but since updating to Excel 2016 for Mac it no longer works: ' Controls the enabling/disabling of all controls with the specified Id. Private Sub EnableControl(pintCtrlId As Integer, pbooEnable As Boolean)...