target.value

Hi all. I am new to VBA and I am trying to make multiselection list over big sheet. My workbook has about 100 sheets. I have also summarization sheet but it is not part of my question. I have following: - in every sheet in cell C2 I have a list - list is defined by name (Formulas -> Defined...

Hi I have a workbook within which there is a worksheet called Actions. In cells H5:H18 I want to reference worksheet Lists, cells C22:C29. I have the VBA for the thing I'm trying to do (allow multiple selections from the drop down list) so that's all fine, but my VBA knowledge is very limited...

In the snippet of code below, what would I have to do to change the way I reference the active cell? Private Sub Worksheet_Change(ByVal Target As Range) '_Change creates the variable as a target, transferred as a value to "ProjectName" Dim ans As Integer If Target.Column = 2 And...

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

Hello all, I have a challenge. I want to do a table that changes its structure. Is about a block of flats. I need to modify the number of stairway and the number of floors (biggest). Here i received a code to hide/unhide the number of stairway. If i have 3 stairways (based on a cell value...

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

Hi, I am very new to VBA and have spent hours searching for the answer to something I'm sure you will all easily be able to help me solve. I am creating an Excel form which expands (unhiding rows) as the user selects drop down options. The first half of the code below works perfectly. When an...

Hello all , I have a problem with a code. I want to hide a number of columns, according to a value of a cell. If value is ='1' unhide "E:K" and hide "E:K". If value is ='2' unhide "E:K" and hide "F:K" If value is ='3' unhide "E:K" and hide "G:K" . . If value is ='7' unhide "E:K" and hide "K"...

Ok pulling my hair out here- trying to get the value from column B in sheet2, by selecting dropdown list from column A I have a dropdown list in sheet1 column J taking values from sheet2 column A I created a defined name for column A and column B in sheet2 "my_defined_name" I added VBA code...

I am getting a conflict between a macro and a workbook sheet change. Both work correctly individually, but the combination is giving run-time error 6 Overflow The macro: 1. Cleans sheet "Combined". 2. Loops through worksheets - copy CurrentRegion and paste as values in "Combined". The workbook...

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

Greetings, I am using this code on a worksheet to change the fill color on a shape dependent on the value in one of the cells. It works great and so I would like to use the same technique in a different WB; but I want to assign it to a command button instead. But I keep getting an error code...

Greetings, I have a worksheet that I use to record the filter efficiency in our cleanroom; This cleanroom has over 400 filters in it. In an effort to give the engineers a "graphical view" of the impact of the filters on the equipment in the room I created a worksheet where I use rectangles for...

Hello I have added VBA code (thanks to this forum) to allow me to add multiple pick lists but I only want it in 2 columns but it appears to be adding the option (& thus duplication issues) across most columns. I have used the code below: Private Sub Worksheet_Change(ByVal Target As Range) Dim...

Hi, I was wondering if someone could help me please? I would like someone to help me alter this code: If Target.Column <> 5 Then Exit Sub If Target.Value = "Azera" Or Target.Value = "N" Or Target.Value = "L" Or Target.Value = "M" _ Or Target.Value = "K" Or Target.Value = "H" Or...

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

Hi all...please help! I'm new to the wonderful world of VBA :) I have a spreadsheet with many pick lists. Some of these should only allow a single item to be selected, some should permit multiples. I have the code to allow multiples to be selected, and have got it working so that it selects a...

Hi, I'm very new to VBA code, was hoping for some help, I have the code below. This works perfectly in my spreadsheet with my data list on sheet 1 and my drop down lists on the sheet "Sep 17". I would like the code to work for additional sheets also, is there someone that can help me with...

Can anyone help me see where Im going wrong. I only want multi select dropdown lists in columns 10,22,46,47,48, I need the rest to be single select or text only. I used the below vba code and altered it for my columns but every column is multi select. I am new to this forum and appreciate the...

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