changed

I have a list of form control check boxes that I am using to change the color of another cell when the box is checked. What I would like to do is when the box is checked to uncheck the box when a reference or another cell is changed. Is this possible?

Hi all, is possibl ecompare 2 sheets with data from A to BR and from row 1 to 1500? why? i captured data, and send to my boos, him do some changes and not know.... wich data changed... then exist a way for detect it? i want compare my sheet with the sheet of my chief. Thanks

Essentially what I am trying to do is copy a table from one worksheet to another based on a selection from a drop down list. I would like for each time the drop down option is changed the table is changed. For example: Worksheet1 A1=Quarter 1 (Chosen from drop down list) A2= Table named...

Hi all, wonder if anyone can help. I have two columns; - E contains dates, in MM-YY format (i.e. 'Feb-19', 'Mar-18') - F contains text ('Same' and 'Changed'). I want to create a formula that counts the number of instances 'Same' or 'Changed' appears in a month. So far I have this: Looking...

I am racking my brain trying to figure out how to highlight the cell if it's formula has changed. For example, the formula in the cell is: =IFERROR(SUM(K5,L5)*VLOOKUP($G5,OH,2,FALSE),0) if a user changes the cell's formula to be something like: =IFERROR((K5)*VLOOKUP($G5,OH,2,FALSE),0) ,I'd...

I have the following array formula, which works great. My issue is the Table[Area]="Yes", can this be changed to contains "Yes". I have tried Table[Area]="*Yes*" but this doesn't work...

won't hold in CSV format from Excel workbook. Every time I reopen the file, it converts back to mo/day/year from the year-mo-day format that I had changed it to. What Am i not doing here?

Hi, I have a task where I copy/paste text from various sources (that cannot be changed) into a single workbook that I then use to upload to Access. I've set up some autocorrects to changed the text into the format I want, but it's a long process clicking on every cell in turn. Does anyone...

Hi all! Please, tell me: -- how to rewrite a DAX-formula for M-notation? it is necessary for slice CALCULATE( SUM(Data[Fact]); FILTER( ALLEXCEPT(Data; Data[ref_Employee]; 'Data'[ref_ts_Project]); Data[Date] <= EARLIER(Data[Date]) ) ) I tried to write the correct...

I have a problem regarding to excel binary combinations. As you see there is a matrix (Matrix 1) with the values of 1 and 0. --- represents N/A or 0. I want to get all different combinations without changing the sums. Matrix 1: <tbody> Sum --- 1 0 1 0 2 1 1 1 1 0 4 1 0 1 --- 0...

Hi all, I have some vba running on my sheet that colour fills a cell if it is changed. Current code is this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A5:F2000")) Is Nothing Then Target.Interior.Color = rgbBeige End Sub However - I am pasting...

Hi, Wondering how to code a macro so it is no longer usable once used. here is my small macro, I want them to click it then it can't be used or cell changed. Sub enterstopdown() Range("H24").Value = Now() End Sub so this puts date and time in cell. then I don't want that changed ever. like...

Is there a way I can run a macro on a worksheet_change event but only if the cells that have been changed are in the range A4:A23?

Is anybody else having problems with the board today? I'm regularly finding that the font has changed & when that happens the page locks & you either have to refresh, or go back.

Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The variable KeyCells contains the cells that will ' cause an alert when they are changed. Set KeyCells = Range("m3:n3,m6") If Not Application.Intersect(KeyCells, Range(Target.Address)) _...

I have been using the Application.Run for a while but something changed and now it won't work! The only thing I changed is that I added the same command in another section of the procedure and I tried to use a goto to run this code but it skips the Application.Run without an error. Anybody have...

Hi, I have 3 textboxes in number format. In texbox1 value = 11, textbox2 value = 5 and textbox 3 value = 11. And I want to count how many number of 11 in a textbox4, every time the value in textbox1 is changed or update. Here's the code I wrote and not working: Private Sub...

I understand that there is 2 lists of control properties. The ones at design time (static) can be changed manually through the VBA Property Window, and the ones that can be changed at run time (dynamic). Is it possible to programmatically change the static ones so I can see the changes in the...

I have a large set of data that I am making multiple pivot tables from. It is basically hours by date. The first table I built was for a summary that I will keep by month. The second is less permanent, but is taking the same data and summarizing by day. I discovered when I went back to the...