xvalue2

Hi, Im very new to VBA and have a code that enables me to select multiple options from drop down. How can I modify this to exclude a certain column, say column B? Private Sub Worksheet_Change(ByVal Target As Range) Dim xRng As Range Dim xValue1 As String Dim xValue2 As String If...

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my excel. <tbody> Category AAA BBB CCC DDD </tbody> In sheet 2, i have corresponding values for this dropdown. <tbody> Category Value AAA 1 BBB 2 CCC 3 DDD 4...

I have multiple cells with drop down lists created using data validation. I would like some of them to have a multi item option and some to be single item choice. The VBA code I am using is applicable to an entire sheet and makes all of the drop downs multi item. Is there a way to specify...

I have an Excel (2016) workbook, on sheet 1 there are multiple drop down lists. On 3 of them I would like to choose multiple items. The VBA code I used changes all of the drop down lists to have multiple items but I would like to specify the drop down lists on the sheet that have multiple item...

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

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