oldvalue

This code works in one TAB (sheet) but not in another. Any help appreciated! Private Sub Worksheet_Change(ByVal Target As Range) 'Code by Sumit Bansal from https://trumpexcel.com ' To allow multiple selections in a Drop Down List in Excel (without repetition) Dim Oldvalue As String Dim Newvalue...

The VAB Code below Work but I only want it in two column numbers 20 (T) and 23 (W) but its applying it to all columns I just want on these two. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo...

Hi there Need some help I put the vba in for a cell to select multiple drop down options and it works :). But when I change it so you can do this to the whole column it don't work and it still only work in the original cell. Its Column T which is Column number 20 but start in cell T8: Sub...

hello, i'm a macro beginner and i've got an error #6/#13 on this 2 code, what's wrong with this and how can i amend it? thank you so much error #13 type mismatch (select more than 1 cell) Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)Dim sSheetName As String...

Good morning. I am new to this site and brand new to VBA. Basically I am trying to add 2 codes to the same sheet but I am not doing it correctly as only one code is working. Could someone please help me? These are the 2 codes I am trying to get on the same sheet: #1 Private Sub...

Good Afternoon, I'm new to VBA codes and need some help. I would like to have the two code below operating on the same worksheet. I've got the first one working but not sure how to add the second. Some help would be greatly appreciate. Code 1) Private Sub Worksheet_Change(ByVal Target As...

Hi All I am creating an email useform wherethe user may need to select more than one email address to send to I have the code below which works perfectly well in a worksheet list but doen't work in a userform. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue...

I need to be able to select multiple list items in each cell of column F starting at F2. I have already created the data validation drop down list for F2 through F infinity. I have found the following macro that can perform this function for one cell. How can I get it to apply to F2 through F...

Good morning everyone, I have a workbook that I would like to have auto-color each worksheet based on a cell value returning as "False". However each individual worksheet is named based on the text in cell "B1" I would like the code to refer to cell "V1" for the false reading and the tab to be...

Hi, The below code enables me to 'click' for multiple selections as the screenshot highlights. However, as can be seen in cell K5: - when selecting '4%' and 'a38%" together - '4%' suddenly become '0.04' and this is causing issues for my lookups. Does anyone know what is causing this issue...

Hello. New to VBA but have seen other threads that say it is not possible to just copy and paste multiple codes into one sheet. Can someone help me merge these two codes below...thank you in advance! Private Sub Worksheet_Change(ByVal Target As Range) ' To allow multiple selections in a...

I have a list I have created under data validation. I need the list to allow multiple selections with the new selection beginning on a new line. I have watched You Tube Video's and played around but can't seem to get this code right. I am a novice excel user. When I use the data validation...

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

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

Hi, trying to combine these two codes to work simultaneously. can anyone help as the second macro works as opposed to both. First Macro: Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo Exitsub If...

Hi, I have the following two codes and would really appreciate if someone could help me combine them. Thank you in advance, Code 1: Private Sub Worksheet_SelectionChange(ByVal Target As Range) With Sheet2.DTPicker1 .Height = 20 .Width = 20 If Not Intersect(Target...

I have VB code running to allow multiple items to be selected from a drop down. The VB code also unlocks and locks the sheet before and after. However, users have the need to proof read the text that others submit and I require that they make deletions in red text and additions in blue text...

Hello- I would like to multi-select from a data-validation list. I found a macro on line which works well. But the note to the macro says that if you save the document, the macro will not work upon opening. I tried it anyway and it did work but it does not stay. If anyone can help, it...

I was wondering if anyone knew if you could have a multi selection drop down that automatically sort the selections alphabetically? I have been searching for hours now, couldn't find anything. The site I found this code on has this question asked in the comments section a few times with no...