form control

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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