Linked Questions

I'm looking for a way to automatically start a certain Sub when the cell's value is Zero. E.g. if I enter "0" into Cell A1 the following Sub is supposed to run Range("H32").FormulaR1C1 = "=SUM(R[-4]...

I have reworked this macro for two days in a load of different ways to try to prevent steps from repeating but the range G2 step seems to run 3 or 4 times and the range G3 2 or 3 times. Does anyone ...

I need to do some operations on a cell after user input. Right now, I'm doing something like this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Target.Worksheet....

I'm trying to add the date and time of the last time a row was modified to a specific column of that row with the following VBA Script: Private Sub Worksheet_Change(ByVal Target As Excel.Range) ...

The simply command in the Sheet1 module: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Range("J5:M5").ClearContents End Sub causes Excel to crash.

So I have developed an algorithm that breaks down a word into multiple parts based on certain rules about letter occurrences within the word. I have managed to debug the entire algorithm and now for ...

I haven't worked with VBA for a while, so my skills are a bit rusty. I've managed to put together a small script that will update the Date Contacted and Date Modified column I have in my excel sheet ...

I have a range in sheet 7, Range("A1:A10"), I am trying below code to get a percentange value in the same Cell, but the Excel hung up whenever i type a number in Range("A1:A10"), ...

Actually using the following code is impossible, because we are doing a change in Worksheet_Change Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = "test" End Sub It will ...

I am trying to make it so if information is entered into C3, it outputs C3*H2 in E3, and if information is entered into E3, it outputs E3/H2 in C3. My code works perfectly fine, but excel crashes when ...

I am facing Excel 2013 crash issues while using a VBA script to lock/unlock cell based on other cell value. Could you help me to find out the error/mistake in my VBA code! Private Sub ...

I have code that very simply when something is entered into a column, it selects all of the worksheets and copies it into those worksheets in the same column in the same row. Why then does the code ...

When I run this code and select yes in the cell "bulk" I keep receiving "please enter the number of labor hours" over and over. Basically what my goal is to have a drop down list to show hidden rows. ...

This likely is easier than I am making it out to be, but I am struggling mightily with a pretty simple concept. I have 3 columns in my excel sheet that I need to validate with one another whenever a ...

Making a simple toroidal 14x14 chess board in Excel, placing multiple copies beside and below each other so it's easier to see how pieces move around the edge of the board. Need all boards to update ...