multiple selections

Hello All So im working on a data sheet for customers, and we want to replace long sample names with a key as a drop down list. So Cells A86 to A90 are the keys (A, B, C, D, E etc). and the matching / corresponding samples names are in B86 to B90 (lower level plain, upper level plain, upper...

Hi , im not even sure this is doable (probably but idk) , basically what i want to know is if there is a way to code a button or something that opens a menu and this menu will do 2 things , #1 - provide a list of cells to select that will show in the list as 1-62 , you can select 1-5 and then 7...

Excel newbie here. I've seen a few threads on this but can't quite get it to work on my end. I originally used the code here: How to Make Multiple Selections in an Excel Drop-Down list and tried it on a test column. The only thing i changed was A2 in line 6 to Q2 to match my column. It worked...

Hello! I have below table with dummy data and what I need is to: - Choose multiple selections from the drop down list without a VBA, is there any trick for that? if not what is the suitable VBA code/macro that you suggest - When I choose multiple selections, what should I update in my current...

hello, I want macro for copy data from multiple(nearly 100) workbook placed in one folder to one master workbook with detail bellow. All work books having sheet name "list" from that sheet I want to copy cells C9, H9, H10 and H24:H29 from which H24:H29 contains formulas but in master work book i...

Hello, I am trying to create a code that will let me make multiple selections in a list, and put the selection in the next row down in the same column. My code works for selecting multiple values, but it puts them all in the same cell. Any help is greatly appreciated. CODE: Private Sub...

Hi I am new to this site, and I am not normally working in VBA excel (IT Project Management), so I was hoping for some help here :-) I am currently making a template for the customer to fill out, and they have asked for the opportunity to select a check box multiple times. Right now, all the...

Hi, How can I select multiple value from a drop down list. Below is the code which I am using for drop down list, but I am not able to find out the way to select multiple values. Please help. If ActiveCell<gs id="0a4e658b-78e8-49e2-a442-66e76086674a"...

Hello there! I'm trying to automate a process in Excel 07 using VB. The problem stems from a copy/paste bug, it appears. Copy and pasting multiple selections using the Copy/Paste command buttons and keyboard shortcuts, using the system clipboard is fine. I always have to go back and delete the...

Hi all, I'm new to the forum so apologies beforehand for any errors while posting this. I'm also very new to VBA coding, but looked around and eventually put together the below code from various sources, with some flaws though. My requirements with the coding are: 1) Select multiple items...

Super simple question - Is it possible to get the value of a selected listbox item once it's clicked? I'm not having any luck. I'm trying: Sub lstMyListbox_Click() z = msgbox("you selected: " & activesheet.lstMyListbox.value & " from the list.", vbOkOnly, "Info") End Sub This... doesn't do...

I am using 2010 and want to select nultiple states (locations) from a list box (would that have to be an Active X control?), then paste the selections along a row in adjacent consecutive cells. For example, my list box would present the user with 51 states. The user would select muluple states...

What I am trying to do is tidy up an Excel report by deleting all the unwanted rows of data. Range("1:1").Find(what:="MCCR*resp*", lookat:=xlWhole).Activate Range(ActiveCell.Offset(1, 0).Address, ActiveCell.End(xlDown).Address).Select For Each cell In Selection If cell <> "ASPF" Then...

Below I have added a table just to give you an idea of what I'm talking about. OK. So I am trying to make a table for my homework assignments that will allow me to put what the assignment is, what class it is for, and when it is due. For looks, and space reasons because of other things on the...