target.value

Eventing. I have the code show below. I need some some advice please for the correct code so when Yes is selected I am taken to a specific folder. I can’t advise the path at present but stuck with the main code for when Yes is selected. Private Sub Worksheet_Change(ByVal Target As...

I have a range of cells in a column, in an Excel spreadsheet. Each cell contains the same drop down list, containing the same "items" to choose from. I have a VBA code (below) that allows me to choose multiple items from the drop down list, instead of just a single item, but the VBA code will...

Hi, I have taken this code from another source that will auto change a time format when entered anywhere on a sheet to show it as h:mm. I only want this procedure to auto correct through range F3:T2000, what can be added to the code so that it works only through this range? Private Sub...

I'm trying to write a macro to email the contents of the entire row for the cell that's been modified... I've already got the code written to send an email with just the Target.Value for the cell that's been changed... rng = Target.Value Puts the value of the cell that's been changed in the...

Hi & Good Morning, I have been working with a code for a while where the cell in question must have 17 characters otherwise the code would do its job. Example SHHFN13408U004767 I have recently had the need to now allow 11 characters. Example RG3-1009939 So the code needs to be working for 11...

Hi, For many reasons the standard Msgbox is no use for me in this case so i have made a userform. My problem lies with editing the code to know accept / use the userform. The 2 text boxes on the userform as advised for you. txtQuantitySold would be the value from the countif formula column F...

ok so I have this macro that works perfectly fine when I'm on this sheet. This is in a sheet that is called "RL". The issue I have is that the cells in the columns 12-19 on sheet "RL" are a result of a lookup from a pivot table. So they are formulas. So when the pivot table (which is a sheet...

Ok so I am trying to automatically have my form in excel change things to proper case when entered. I found a code that works but then seems to crash excel or kick me to debug here is what I have please help in fixing it so it works. Private Sub Worksheet_Change(ByVal Target As Range) 'Update...

Hi everyone, I have a sheet with two blocks of data. On both blocks, I want to hide a different number of rows, using the following code. The thing is that VBA says I can't have two of the same. Is there a way to have one (or more) macro(s) have multiple Worksheet_SelectionChange(ByVal Target...

Hi How do check if H2 = B2 and have a message if not , I have this so far. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "H2" Then If Target.Value <> "B2" Then MsgBox "Wrong Sku!" End If End If End Sub Would like it to work on all cells in H and B

Hello all, I've found quite a lot of usefull tips on this forum by just looking around, but I can't seem to find this answer for this problem. Keep in mind that I have next to no knowledge in VBA of coding in general. I have found two codes that I would like to use simultaneously on the same...

Morning all, Can you advise how i would go about the following request please. Each day i would enter data into my worksheet. The cells in question are always the same. The cell the data is entered into is A17 As i leave this cell in question i would like some code to look at the 10th character...

This code works but once I trying updating a cell the code stops working. here is the code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Call Macro1(Target) Call Macro2(Target) Call Macro3(Target) Call Macro4(Target) Call Macro5(Target) End Sub Sub Macro1(ByVal Target...

Hello, I am trying to make multiple selections in a drop-down list in Excel. I know the only way is to use a VBA code. I have my drop down list in Data Validation list in Column G, and my drop down in column I. Here is the vba code that i'm using.... and it's not working. I did the code exactly...

Hi i have the code below but this works for all of sheet1 and i only want the code to working in column H and down only please can you help for example .Range("H") but i dont know the exact code or where to put it, and i want it to work on new line as well when data entered. I hope you can...

Hi, I have the below code that filters a pivot table based on a cell value but if the cell value is blank it errors out, not sure what I'm doing wrong as it seems simple - any help appreciated. Private Sub Worksheet_Change(ByVal Target As Range) ' Filters Pivots table on Market Name If...

Hi, I have the below code, which enables me to select multiple options from a drop-down menu. However, I want to amend this to column I, J and K - but the code is not letting me go any further than I37 (it goes red). This does coincide when it moves to the next line if this could be the issue...

I've been trying to combine to separate change events in my VBA code. The first allows users to insert hyperlinks into specific columns and the second enables multi-select drop-downs in other cells. The problem is I can't get them to work together. One always over rides the other. I've read...

Assistance needed to break this Code down to a smaller version as I am getting a Compile Error - Procedure too large. Current Code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$BA$4" Then Shapes("A 1").Width = Target.Value * Range("BA157") End If If...

Thanks for looking at my post. I am trying to figure out how delete the text typed in cell AE30 at the end of the code below. Sub worksheet_change(ByVal target As Range) Set target = Range("AE30") If target.Value = "unprotect" Then Call up_all_sheets End If If target.Value = "protect" Then...