worksheet change

I have a form, where I have a Worksheet_Change event which adds a new row once data is entered in a particular cell. So my form only has one row, but will keep adding rows as required. When data is entered in cell E12, it copies the current row and pastes it below it, clearing all contents but...

I'm using the following code to clear different lists in different cells: However, all of them work except for If Target = Range("T5")... which clears all the data validation lists instead of just T6 and T9. Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target =...

Hi All I'm reasonalby fluent in excel but my vba knowledge is limited. I'm looking for some help with a code to scroll down to a specific title when a selection is made from a drop down list at the top of the page? looking to save a lot of scrolling and ctrl F time please help Cheers!

Hi, I am not very good with VBA but, I'm trying to change the Y Axis to a value in a cell (basically i'm trying to tighten up the auto setting). I would also like it to only happen to a specific chart (Chart 45) every time the cell changes. I have managed to find some code that I think may work...

I am not an expert, but managed to create these two vbas that work fine, except that it loops after every single cell change, and I probably need to combine into one vba. I only need to look at C54:D54. The tab color change feature needs to look at cells C54:D54 (not A56), and if the value is...

Hi all, I have a worksheet change macro, which checks the value inputted into CELL E5 (Toy Code), it will then match it to Column B in another sheet and pull back a row of data. I would like to do this macro AGAIN in the same sheet however checking if CELL H5 has been inputted/field has...

Hello for the life of me I cannot get these 2 worksheet change events combined. Below is the code of me just pasting one after the other in the same sub. They work seperately but the bottom one doesnt work when they're combined. Thank you. Private Sub Worksheet_Change(ByVal TARGET As Range)...

Hi, I am utilizing tags that are imported using a 3rd party program, and they gradually change over time. What I want to do is set up my program so that I can leave this workbook up continuously, and have the sub run every time the tag is updated. There are a variety of locations where these...

Dear all, I have something tricky to do in VBA and since I just started on this malarkey, I am a bit lost. My actual macro calculates what is called "Min.DR". This is calculated based on trends in sheet "QLT_SS_Input" (steady state cases). The min DR is then copied into the output tables...

Hi There. I have found a sub that will dynamically update named ranges in worksheets. There are two things that I would like to know if possible. First, I would like to know if there is a way to disregard blank cells in that range (starting at A3 that goes to the last row). I am using that range...

Hi, Just wondering if you can help me. I have the following code in my "Dashboard" sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Range("BM48") = 1 Then MsgBox " Please enter either % OR Value.", vbExclamation, "Average Fare."...

I need my workbook to refresh data whenever a new tab for a worksheet is selected. I looked around on several sites and couldn't find the syntax for this. I have a function below for refreshing the data and I was planning on calling that function that if a tab was changed in the "ThisWorkbook"...

I am attempting to write a bit of code so that Vlookup is called when a particular cell in my spreadsheet is populated. Although it seems to be working, it is only pulling in the data in row 1. An example of the code is below. Any help would be greatly appreciated. Justin Private Sub...

Hello All,</SPAN> I am very new to VBA so I would like to apologize in advance if this is a highly trivial and basic question.</SPAN> With that said I am developing a workbook that will ultimately end up serving as a database. In the workbook, there will be ~120 tabs with each tab...

Hi everyone! I need a code who identify the last value of column D of worksheet "Data" and put this value + 1 in worksheet "Form" cell E3. So the cell E3 of worksheet "Form" must have automatically the last value of column D of worksheet "Data" adding + 1 to this value. If no values in column D...

I am trying to use vba code to allow multiple entries in one cell using a data validation dropdown list and the Worksheet change event. It just does not work and I have spent hours trying to figure it out. The code works on a sample spreadsheet I downloaded with the code. I have an MX tools...

Hi All, I have an Excel worksheet where one of the columns should only contain entries that begin with a number, for instance, a cell with a proper entry might read: 1 BOOK (or 2 CASES or 3 BOXES for that matter). I would like it to be the case that with any entry that does not begin with a...

Hey, I am looking for some guidance on developing some code to do some worksheet change event code. I have a situation where I have 4 columns, (A,B,C,D). The values that are in these cells are all interconnected (you can find A with the value in D or value in C from the value in A). I am...

Cross-posted: Have a worksheet where I'm trying to code in three things: 1) An Auto-Sort once data is entered in columns 1-7 2) A worksheet change event that runs my main macro when data in the table is changed 3) A security feature that locks cells in column 7 when column 10 = "Yes" I've...

Hi all How would I have the worksheet_change event enter the date a cell was changed into the adjacent column? For example, if a1 = "Yes", b1 = "2012-08-06". Thanks much!