xvalue1

  1. P

    Excluding a column from VBA

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

    Value retrieval from the Multiple selection dropdown in excel

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

    multi item drop down items and non-multi item drop down lists on the same page

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

    multiple items from single drop down list on a sheet that has multiple drop down lists that I do not want multiple choices

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

    naming a range for column 'H' in excel using VBA

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

    VBA Multiselect & Single select lists

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top