newval

Hi all. Got this VBA which is supposed to enable the adding and removing of more than one name from within the same cell. It's supposed to behave that if you click the first name it puts it in, if you then click a second different name, it puts that in too, if you come back next week and select...

I'm kind of new at using VBA codes. I have a worksheet that so far zooms in to see the drop down list. Now I'm trying to have the VBA have a way to be able to multi select from the drop down list. Here is the code that I am using. Private Sub Worksheet_SelectionChange(ByVal Target As Range)...

I've been trying to combine to separate change events in my VBA code. The first allows users to insert hyperlinks into specific columns and the second enables multi-select drop-downs in other cells. The problem is I can't get them to work together. One always over rides the other. I've read...

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

Hello, I am doing my best to learn and understand VBA coding, and this one particular piece of code I think I have an idea of what it is doing, but I would rather be absolutely sure so I know I understand it completely. Could someone explain what this is doing? It would be great if you could...