Programming

sumif
i am using a sum if in a formula and i want to copy and paste it down my spread sheet. when i do excell changes all the cell references down 1 number. the only number in the sum if formula i want to have change is the critria, i want the range and sum range to be the same for all cells involved. i would just ty... 22 Mar 2010 18:06

HELP: how to locate objects on userform from VBA code
Hi All, How do I locate objects on userform based on the VBA code? For eg: I have some events like StudentYes_Click and StudentNo_Click in the VBAProject and there is some code in those events. I tried Debug --> Compile but didnt get any compile errors. So I am assuming I have those two radio buttons somewh... 23 Mar 2010 05:39

show and hide a drop down list
I have a drop down list in my sheet. Based on what is chosen there, I'd like to be able to show or hide another drop down based on the chioce of the first one. Is this possible? Thanks ... 22 Mar 2010 16:52

Choosing a drop-down menu selection returns value to another c
Hi Barb, So far I only have the code to return the active cell value to A1 and the active row # to A2: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1") = Target.Value Range("A2") = Target.Row End Sub When I select from the drop-down list, it doesn't populate A1 immediately. A1 r... 22 Mar 2010 16:52

between
In cell m3 is 1/1/2010 in cell n3 is 4/1/2010. (the actual year will change every year) I want to say that if the date in cell z3 is between the date in M3 and the date in N3, return 1 I don't find a function for "between". HELP please. ... 22 Mar 2010 15:33

Lists not working w/ userform
I have a userform which is supposed to find a value in column A, then find all corresponding values in col B. Somehow, it's not working. Here is the code: Private Sub cboCode_Change() Dim rCodes As Range cboFacilities.Clear For Each rCodes In Range("codeList").Cells If rCodes.Text = cboCode.Text ... 22 Mar 2010 13:06

Search for userform or procedure name?
Tried to search XL files in Windoze Explorer for userform, procedure and module names - doesn't work. Does anyone know of a search tool that can do this? Sure would be handy! Thanks in advance. ... 22 Mar 2010 16:52

VBA IF THEN with an OR
I would like to have an IF Then statement that is of the ilk, If this or that then... How do I put the "or" part of it in there? I know how to do the or(x,y) thing in a worksheet. Thanks, Papa J ... 22 Mar 2010 14:16

Complex Excel formula help
I need help trying to create a complex excel formula. I am creating a spreadsheet for patients in a Health care rehab facility. By law, they are required to receive 900 minutes of therapy for every 7 day they are admitted, or 3 hours for at least 5 of 7 days. I have created a formula, using the COUNTA function, tha... 22 Mar 2010 14:16

How to determine which sheets appear on opening a workbook.
Is it possible to determine which sheets appear when a workbook is opened. I have a workbook with a number of hidden sheets that are updated by me from time to time and I would like them to start off hidden when the workbook is opened by say, someone else on the network. I have toyed with the Workbook Open in... 22 Mar 2010 13:06