form control

I am in desperate need of some help with some form controls. I need a way to manipulate a group of check box forms and/or combo box forms with a macro assigned to a single form control. For example, clicking a single "check box A" would check off all the boxes in an associated group. Is this...

I have an equation that I would like to be able to have spit out 3 different outputs depending on which opion button is highlighted (Standard, Conservative, Aggresive). I cannot seem to get the equation to work for Conservative or Aggressive. Any help would be great.Tyler Private Sub...

Hi Everyone, I was wondering if there is a way in excel-vba to do this. In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the...

I have been doing Excel VBA for over 10 years but I never got into the form section of Excel and I don't even know how to. I have a button and assigned it to a macro and I have used this macro in several places but somehow one of the buttons got renamed. I am told I need to get into the Form...

Hello all again, I have a form control listbox, which is populated with filenames from a specific directory. When the user selects an entry I need that text to appear in a cell in the workbook. This is then concatenated with a folder path to open the file to copy and paste some data out into...

Hi there, I am trying to have a checkbox (form control) appear based on a value in the previous cell. If the cell value is x I want the checkbox to appear. If the cell value is N/A I do not want the checkbox to appear. any help would be GREAT!!! Lauren

I have a Combo Box (Form Control, not ActiveX) which is Unlocked. When I protect the worksheet it returns this error when I click the box: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the...

Hi All, I'm making a dynamic chart with code I found online (peltiertech.com), it was a post from 2009 so I hope you can help: Sub ClickSeriesCheckbox() Dim rCell As Range For Each rCell In ActiveSheet.Range("TrueFalseRange").Cells rCell.EntireColumn.Hidden = Not rCell.Value Next End...

I have a form control text box with a fixed width that expands downward to accommodate however much text is entered in the box and the text is set to wrap. My problem is that if a carriage return is used anyplace in the body of the text (like to start a new paragraph), then the last line of...

Please read and assist if you have a solution...:confused:. I have worksheets that require a check boxes to hide or unhide Charts or additional worksheets - nice feature! After a (un-repetetive) few clicks and or unclicks the check boxes freak out and the text associated with the check box...

Hi Is there a way to copy cells that contain form controls so that the references become relative? I have removed the dollar-sign from the cell link field but that doesn't help. The new cells and form controls (spin buttons) get the same reference as the copied form control. Do I really have to...

My first post. Have searched every available discussion of screen flicker for Excel VBA (mine is 2007), but have not found one like this: Widely acknowledged that when ScreenUpdating returns to True it redraws the screen. My ActiveX Buttons on the visible worksheet flicker during this redraw...

I have a locked sheet where the value of A1 is tied to a form control. It seems the only way for A1 to update is for A1 to be unlocked. Is there a way to keep A1 locked and still allow it to update depending on whether the control is checked or not? Any help would be greatly appreciated...

I am new to VBA. I am trying to figure out a way to change the background color of a button that I am programmatically adding to a Userform. An example of the code I am using is a follows: Dim rnge As Range Dim ws As Worksheet Dim cControl As Control Dim c As Integer Dim NName As String c = 1...

Surely someone has made dependent List Box (Form Controls) before? How is this done since you cannot use INDIRECT()? I've tried searching, but everyone references the Data Validation / Indirect method? I'm looking for something that would use the List Box Form Control. Thanks!

I am entering Option Buttons on an excel worksheet, using form control. I have 40 questions, each with 5 options. The option "reports" in the next cell to the right of the question group box. I have set up 37 questions just fine, but when I try to set up the 38th (or 39th, or 40th), it...

(N.B. I'm trying to do this without VBA, which I don't know. I'm not sure it's possible, even with VBA...) I'm trying to create a 'data entry form' (i.e. a sheet that looks like a data entry form, complete with Form Control checkboxes, text boxes, maybe some data validation drop down and/or...