Linked Questions

So I have a data validation in once cell that changes to one of three different named ranges based on a user selection in another cell. What I need is for when the user selects a certain value, i.e. "...

I need a message box to appear when the value in cell G27 exceeds the value in cell K13. I require this to show up as soon as cell G27 is filled. I have tried the following macro, but it is not ...

I was looking for a code to automatically insert the ':' (colon) into the columns R and S, W and X, and found code that I thought I could customise to my needs, but I am facing two issues: The code ...

I have 4 Cells (S11:T12) and a Command Button 1, what I want is, until all 4 cells are populated the command button should be disabled (Which I can do from the properties tab) and once all 4 cells are ...

I am trying to insert a username when a specific value is filled into a cell. Example, If Cell X14 is set to "Done" or "Skip" by a user, then I want Cell Z14 to have username, who's currently ...

I'm trying to have a range of cells (Installation Agreement: parts of i column) populated with the number in (Assessment : C4) every time I make an adjustment to the "Job Report" sheet. But it's not ...

The first part of the code works; when the user changes the cell to ACC, it inputs the right values. However, if the user deletes it, then I want the comment and the content of the cell next to it to ...

Option Explicit Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim rngF As Range, rngC As Range Dim aCell As Range, bCell As Range Dim wkSheet1 As Worksheet 'recursive ...

I've been working Worksheet_Change VBA code in Excel as shown below. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A2:A2000")) Is Nothing Then Call writetag ...

I have a problem with VBA, I need to use the worksheet change event to pickup cell values from AI28 to AI30 and move them over to V28 to V30. This is what I have do so far Private Sub Worksheet_Change(...

I am trying to find out how to get a database to automatically sort alphabetically using VBA in column A. Sounds easy, but I have headers in the first 4 rows and want it to sort from line 5 downwards. ...

I've been trying to run the below code, but whenever i change a value to 0 in column I, nothing happens. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim ...

I have an Excel sheet as below- Cell No / Column A ------------------- 1. Total 2. $1,350.00 3. $2,670.00 4. $2,891.00 5. $1,107.00 6. Drop-Down List I have added Data Validation ...

This one's a little complex but I feel there might be a simple way to do it. If a cell in a column is changed, I am looking to find the row containing that modified cell and copy a cell from another ...

I tried running a worksheet change macro and it seems that when I had an error (due to data validation from a list) in one of the cells and then clicked somewhere else in the sheet, then the excel ...