keycells

Hello, I have a workbook that was previously working with no issues. Recently, however, I have been having a problem with adding/deleting columns on visible sheets after I run certain macros. The workbook is used for groups of members. When data is imported into the file a base number of...

I am trying to have the cells that are inserted be based on the keycells range. I had everything working properly but had massive delays when I tried to insert a substantial amount of columns. I then switched methods in inserting the columns which drastically speed up load times, from 45+mins to...

I have a worksheet change event that will add columns to worksheets based on a value. I am trying to get it to add columns to certain sheets based on one value and add a different amount of columns to different worksheets based on a value from a different cell. The code is: Private Sub...

I am trying to create a worksheet that will create columns depending on the value of a cell. So if I input 10 as the value, 10 columns will be created with the appropriate formulas. I was able to achieve that, however, I would like the range to pull a value from a different worksheet. I wasn't...

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...

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...

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...

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 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...

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...

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...

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...

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...

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...

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...