value change

Hi All, I have several Radio button selections as part of an Order form. Radio Button A Options - Yes (1), No (2) Radio Button B Options - Yes (1), No (2), N/A (3) Radio Button C Options - Yes (1), No (2), N/A (3) If Radio A is selected as No, then B and C are not applicable. Rather than...

So I got an excel file where within I got a list of Perks from a game. Now the problem is, when the sheet is Protected, the function to move a cell's value(the perk names in this case) under or above another perk in the list. Is there a way to enable the ability to use this feature somehow...

Hey guys, need a little help here. I'm working on a proposal sheet for a business and I want to add a button on the top that would let them reset the quantities all to 0. I have a "Description" column that has values such as header, product, description, and subtotal. Basically what I need is...

Hey there, Sorry for my poor English in advance, am no native speaking and writing person. This question has to work in Excel 2007. For an sheet what we use to store the hours as an indication for what we need, I need a formula. But no idea how to get it done since my knowledge of Excel is...

Please help. I know this should be easy but having trouble getting this line to work; P1 = Worksheets("Past-here").Range("B" & i).Left(cell("B" & i), 2) I get a "type mismatch" error. I need to check the data in a worksheet for several types of data, such as 100, 109, 400, 300...

I’ll give an example to hopefully make this faster. In Column "Tear Height" or column AJ, row 161, I have a value of 200. Going down the table (each row is a new bond for what I’m doing, so a parameter is going to be changed. It will not always be the same parameter changing), the value of 200...

This is the strangest thing I've seen excel do in a while, I've got a sheet that I want to know when it was last changed. So I added the code below to an existing On-Change program When this code is in the macro, whenever I enter a value and press [enter], rather than going to the cell it...

Greetings, I am currently working on a project with 1500 workbooks. As each workbook is updated, a column in the tracking status of each workbook is changed to "Complete" using data validation. At the bottom of the worksheet, formulas are written to give the percentage of each catagory: "Not...

Hallo, Ik heb de volgende functie gemaakt: =SOM.ALS($H$2:$H$500;TEKST.SAMENVOEGEN(N$1;$K$1;$K2;$M$1;$M2);$C$2:$C$500) Ik wil graag de stukken $H$500 en $C$500 aanpassen met een getal uit een cel. In dit geval cell I2. Wat dit zou doen is elke keer als cell I2 van nummer veranderd, veranderen...

I am pretty new to Excel Macros & I have following code in my current spreadsheet as macro to highlight a cell when cell value changes for Column C. The way it works is **************************************************** Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1...

Hi All, I have a code that clears the content of a cell if the value of that cell exceeds two. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Cells(1, 1).Value > 2 Then Cells(1, 1).ClearContents End Sub My problem is the value of this cell comes from a function and...

I have a workbook that has started to do something odd. On 1 tab only, every formula I attempt to enter now automatically calculates the value and replaces the formula with said value. It only does this on 1 of the 2 tabs. It does not matter what formula I use nor which cell I attempt to update...

Hi all, From many daily reports, I copy some data into a master excel file. These data include dates with different formats, e.g. 15/10/2011 or 15/10 (date/month) or 1400/09 (time/date) or sometimes only 05 (date). All these are pasted special as values into the master file. The problem...