dropdown

Hi! I would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e. Question 1: Yes = 2 No = 0 Question 2: Yes = -1 No = 0 etc... How can I do that? Thanks in advance! :)

Good morning folks. I usually manage to find solutions by scouring forums but this time I've drawn a confusing blank. I've found stuff which partly solves the problem but I can't assemble a complete answer. So here goes. I have a) fixed data ws1.Range("A1:A3"). b) dynamic data in...

Hi, I would like to try and edit this formula to return non blank cells for a dropdown list: =INDEX(Results!$A$2:$S$183,,MATCH(A55,Results!$A$1:$S$1,0)) The range that I would like to omit the blanks from is Results!$A$2:$S$183. I also cannot use an array formula as I need to put this...

I'm running a sub from PERSONAL.XLSB that assigns a DropDown to the active sheet. Below is how it's being assigned. Dim ddFilterDropDown As dropdown ' Add a new filter dropdown Set ddFilterDropDown = rngDest.Parent.Shapes.AddFormControl(xlDropDown, _...

Hi, I have an excel template which can be used by different users. I would like to have a macro that expands or collapses a group of cells when a specific user-type is chosen in a "user" dropdown. Details: Dropdown is found in cell A4 and has option of choosing user A or user B. If user A...

Hello, I'm relatively new to access so thank you for providing any insight you can. I have a Combo box in a Form that lists a bunch of names. I have the source of this dropdown pulling from a table called 'names'. When a user clicks the dropdown in the Form and then begins typing - it...

Good day, I am looking to get a button to press that will cycle through a dropdown list and print. For example, on Sheet "Hourly" I have a print area set. The dropdown is in J2. There are roughly 50 items in the dropdown. I want the button to be able to go through each listed item in the...

I need help figuring out how to select multiple dropdown box options, without repetition.

Hello, Hoping someone can point me towards a solution on the following: In tab "model", I have a model that outputs data in cells B2:G104. This is based on a dropdown selection in cell I5 that pulls from a list in tab "List by SL", cells B2:478. Cell I8 in the tab "model" is an index match...

Hi All, I have a drop down with 4 options, depending on which option is selected the corresponding sheetname would be selected and column A would be copied to the clipboard. e.g the dropdown values are as follows ebay, amazon, otto, tesco and the sheetnames are the same Any idea how this...

Hi Friends, I am stuck with one thing in a User form . I have a dropdown where the data is taking from a sheet. I want only unique values in the droplist. I already have the code , but can someone please help me to edit this code which will give only unique values in the droplist. Note ...

I have a list of Presidents in B2 with a dropdown. I would like to loop thru dropdown in Cell B2 of "Test". Then copy contents from A1 to end and paste in new sheet for each change in filter ie called "Test_Washington" , "Test_Kennedy" etc

Using a dependent dropdown, I have multiple values all with different source locations. I have used VLOOKUP to automatically populate a cell next to a drop-down. =VLOOKUP(C13,'SheetX'!C5:D5000,2,FALSE) However if I select B from the drop-down, how do I get VLOOKUP to do the same thing? The...

I'm trying to add a simple drop down list to a VBA form. The list will have only two items from cells OK65 and OK66 of the active sheet. Can someone help me get this dropdown list to work? This is the code I'm using: Private Sub cbofield_Change() cbofield.List =...

Hello, I was wonder if there is a way to increase the width of a dropdown list. I know that the width of the list is usually the same as the width of the column it is inbut I was wondering if it was possible to make it bigger all of the options are cut off. I've tried to use this code but it...

Hi all, <tbody> Manufacturing line Type1 Type2 PPA New product PPA ELH Basic PPA Old product ELH Advanced ELH </tbody> I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected. So if I select PPA New product...

I’m trying to select a value on the html dropdown box with excel vba code (as far as I know the html is javascript) but I’m not good at html. I have tried every possible proposal from various forums, without luck. The web page is an internal company page, so unfortunately it cannot be shared...

Hi all, I have created 2 tabs Data and Form, Data Entry Form. With Name, Date, Item No, Outcome (dropdown) and Comment. Along with Save and Reset Buttons. Could someone please help with VB for me. Thanks JJSB

Hi could anyone help me with this i'm going number blind! https://1drv.ms/x/s!Aszg_mMOoSFEgSM203OyZbldchOt?e=LLq6Ur When I select TU1 in C7 I get the correct results from the table $J$14:$O$20, but when I select TU2 from the dropdown in C7 I'm not getting the results I need? Can someone...

hello, i have created a dropdown list which i would like to link to another cell. the data from this cell will then allow a vlookup to operate in a 3rd cell. essentially: - M9 = dropdown list (1, 2, 3) - F6:F8 = cells that dropdown list refers to (a, b, c) - M13 = vlookup on F6:F8 i...