form control

  1. brendalpzm

    Clear combo box when changing option button

    Hello~ I have form controls option buttons that are linked to an activex combo box, Depending on the option button the activex combo box changes its values. The issue is that when I select a value from the combo box and want to change the option button (this can happen when the user makes a...
  2. T

    Connect Form Control Button with Public Function

    I need to understand how to connect a form control button to a public function. I am attempting to create a button for users to 'save as' an exe file that can only be opened by a specific application. I am still learning VBA and trying to use a public function for the first time. I have spent...
  3. M

    Worksheet form control shape properties not all available when workbook is minimised

    I have been using the function Workbook("file name.xlsm").Worksheets("Sheet 1").Shapes("command button 1").texrframe.characters.text = "my text". This works perfectly and changes the text on the command button. .Caption and .text don't seem to work at all However, if the workbook is minimised...
  4. M

    Keep IF formula but be able to change quantity if value is true

    Hi, I have a cell that has an IF formula and a Form Control linked to it. If I click the up arrow, the cell input goes up one increment however the IF formula is removed. How do I keep the rule in place but be able to manually enter quantity if value is true? OR Can I get the Form Control to...
  5. R

    inserting values in next open space on list.

    Hello, On picture "actiondeck"(blue) when I select the "no" form control option box in Row 8, it makes cell "R8"=2 an dbecause of that makes cell "P8" Red. What I am trying to do: is that when "R8" equals the value 2 or 1 then it will report the question number("1") in the next available row of...
  6. S

    Copy worksheet from template

    Hello, I have played with this and still can't figure it out. I have connected this macro to a check box: Sub copy_Sheet() Dim wb As Workbook Dim activeWB As Workbook Dim FilePath As String Application.ScreenUpdating = False Application.DisplayAlerts = False...
  7. Z

    How can I create a form control within a macro?

    I made an excel add-in that creates a report from a site automatically. I would like to add a form control to that report linked to another sub in the add-in file automatically. This is so the user can run another report just by entering a value in a specific cell and pressing the form...
  8. J

    Form Control Grouping Greyed Out

    Hi all, I'm creating a set of checkboxes for a multi-series chart so users can select which series to display. I'm trying to group them into a groupbox but the option is greyed out/disabled: I can create the Group Box via the Insert option on the Developer Tab I can create and format my...
  9. D

    Mutli Use Form

    I combined three forms into a mutli use form and would like help in figuring out how to modify current code to work. I would like to be able to change tab order and shade areas of form I don't need for curtain task based on wihcih command button used on menu page. Here is my current code.( some...
  10. A

    Filter Data with Date range. Dates would be selected in user form calendar start data, End Date

    Does anybody could help me to create a user form, that user could select the start date and end data from calendar and the VBA code would filter the data on Excel SpreadSheet depending on input dates I want user to specify start date and the end date, that I would know the period of time which...
  11. H

    Extract Multiple Selection Form Control Data

    Hi - I’ve got a worksheet with multiple ListBox form controls (not ActiveX) that I need to extract the selections/inputs from. There are 6 different listboxes all with multiple selection and about 40x of each. They are aligned by row, e.g customer 1 in in row 1 has listbox 1 in column A...
  12. F

    Replicating Form Control Buttons Across Sheets

    So I am a bit of an Excel neophyte. Sadly, I am also the Network Admin at my worksite and as such am expected to know how to do anything computer related. Our payroll system is done entirely using Excel 2013. There is a workbook for each user and a sheet in each workbook for each pay period...
  13. K

    Malfunctioning: Microsoft Date and Time Picker Control

    Greetings, I have a question for which I cannot find the answer to anywhere. I'm using the Microsoft Date and Time Picker Control in a form at the request of leadership who want to choose the date for the form. The info doesn't go anywhere, it just shows up on print outs. The problem: This...
  14. R

    Form Control Checkboxes (Not ActiveX Controls )

    Hi Everyone, I'm still new to coding and looking to learn more. One thing I can't figure out and I'm 100% sure its so easy. I am doing this through a Form Control because I know that ActiveX controls on an excel sheet causes resizing when the screen resolution changes. So I have a Checkbox...
  15. D

    Form Control, Option Buttons

    Firstly my apologies as I know this has been asked before but I still cannot get it to work. I'm using option buttons from the Form Control menu, the ActiveX Control menu is ghosted, as is the design toolbox button. I have no idea how to un-ghost them. No matter how I group and re-name and set...
  16. D

    Open a new task in Outlook with a Macro

    I have a spreadsheet where I update the status of different projects I'm working on. I just want a macro that will open a new task box in Outlook, and maybe add the value of a cell as the subject. I don't want to assign to anybody and I will finish setting it up in Outlook. I just need...
  17. E

    VBA to Select All Checkboxes FormControl

    Hi I have a code to select/deselect all checkboxes with one "master" checkbox. This code is for OLEObjects/Active X controls, and im having a hard time rewriting it to work with Form Controls checkboxes. Any idea? Private Sub CheckBox1_Click() Dim i As Integer For i = 2 To 39...
  18. B

    VBA test to check if a specific Button (Form Control) was clicked

    I have a button (form control, not ActiveX). I renamed this button "butVA03". I also have 15 other buttons in my excel sheet, but I want a test to check if "butVA03" was the button that I clicked. Is this possible? My suspicion is that I'm not defining "butVA03" correctly as a specific button...
  19. H

    Audio equalizer type control on VBA Form

    Hi, I am trying to design a VBA form. The form will contain a table with 12 columns for 12 months from Jan to Dec. These columns will have certain values. And simple line graph will be drawn showing the yearly trend. This is fairly simple and I can achieve this. Now, what I want is control on...
  20. andrewb90

    rows not hiding properly

    Hello all, When this code runs, select rows are supposed to hide when the value of column F is TRUE, but I'm not sure why it's not working... Sub Hiderows()Application.ScreenUpdating = False Rows("4:10").Hidden = False For r = 4 To 10 If r <> 7 Then If Range("F" &...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back