keycells

  1. O

    Crashing Code

    I'm trying to make a spreadsheet such that when the day changes (Cell B2), an operator changes another cell and a third cell is cleared. On top of that, whenever a value is entered into a fourth cell, it is added to a fifth cell and the fourth cell clears. My code is below. When I enter a...
  2. M

    Streaming Data: On Cell.Value change, do stuff

    Hi, So I have this sheet that gets streaming data from another app. I want to execute some code when the value of some cells change. I tried Worksheet_Change method but it does not detect changes to the values(Im guessing it only detects manual input?) Stole this method from the forum, have no...
  3. M

    VBA 1 cell linked between 3 sheets work but a second cell doesnt

    Hi! Ive got a code running in my sheets codes where in Sheet 1, sheet 2 and sheet 3 have a cell that when you change 1 the other 2 also change. Now I want to ad a second cell on each sheet that does the same. But I cant get it to work. This is the working code for the first cell. Private Sub...
  4. R

    Run Macro 1 automatically from cell change and another macro from another cell in same sheet

    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)) _...
  5. G

    Active Cell Issues

    I am building an application form in excel, whereas the applicant will only be able to edit unprotected cells. I have included coding so that the number of applicants, number of facilities, and number of collateral accounts can be populated to the correct spacing in the form. For example, I...
  6. S

    Detect when individual cells were changed, cells not in a range...

    Hello, I have a snippet of code which detects when a cell in a range is changed. I'd like to use it to detect when several cells not in a continuous range on the same sheet are changed...one option would be to define a bunch of ranges and do-while through them all, I guess. here's my starting...
  7. J

    Shape Rotation Animation Speed

    Hi all, I have created 4 gauges with shapes, the dials of the gauges are a shape that's been regrouped at the 0 degree mark on the gauge and moves according to the % of the value * the degrees of the gauge I've created. When I select a new set of values based on a data validation list, they...
  8. S

    [VBA] Capture a value before a cell converts it into date format

    Hello, I want to write some VBA that does the following: user enters an integer into a cell store the integer change the cell value to '=today()-integer' I have pretty much got everything I need written, the problem is, I am using Target.Value, which is showing the integer converted into date...
  9. J

    How to re-calculate sheet on change in Format of a cell

    I want the re-calculate sheet (F9) when there is change in format --- from bold to un-bold and vice versa in Range ("A4:A65536"). I have a tiger code for change in cell values. How can we add the BOLD/UNBOLD aspect? Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The...
  10. P

    VBA run when cell selected in range containing specfic text not working

    Hi, I am trying to write a code then when someone clicks on a cell in Range G8:G1007 if the selected cell value is 'Copy' it copys the cell 2 columns along on the row that was selected but I can't work it out! Any pointers? Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells...
  11. U

    Yes/No vs. No/Yes

    Hi, A product can either be for surface use or for subsea use - not both at the same time... <tbody> Surface Yes Subsea No </tbody> I have made Yes/No selectable from a dropdown. But... These two fields (B1 vs B2) must be of opposite values... Ie. If I select B1 as Yes, then B2 should...

Some videos you may like

This Week's Hot Topics

Top