multiple select

Hello. I'm using the code below in a worksheet: I found the tutorial on YouTube and the dropdown list feature multiple select of values. It works perfectly!! Except for one thing. When I click to protect the sheet, the multiple selection feature goes away. I'm able to select a single value but...

I have been trying to search how to do this and have not come across anything that helps me with what I am trying to accomplish. I have seen select statements with multiple conditions, but not multiple actions. I am trying to replicate a calculation based on if the action is done daily. I am...

Is there a way to allow multiple selection delete? Like the user selects more than 1 cell and pushes the delete button without causing an error to a macro? I know to allow multiple selection is something like Target.Count > 1 . How can we incorporate if the user deletes multiple cells? Also...

I have not found a good answer to this...in the newer versions of Excel, you can keep selecting a cell or group of cells multiple times if you hold down the CTRL key, it will get progressively darker. This is fun for distracting myself by making patterns with the selections, but is there an...

Hi All, I have made a drop down list named "Region" (In cells A3:A2500) and a dependent drop down named "Area" (In cells B3:2500), Both are made using named ranges 'Region' and 'CGM', 'HIOW', 'HLNY', 'Merseyside' or 'WY' (depending on 'Region's selection) I have copied and pasted the...