Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [dropdownlist]

A drop down list is a list with predetermined options that expands when clicked to reveal the options available.

0
votes
0answers
16 views

Dependent drop/down list 2x on same base selection

I want to create two drop down lists which depend on the same cell selection. I managed to create 1 dependent list via a combination of the name manager + =INDIRECT(), as is instructed on this page ...
1
vote
1answer
58 views

Conditional defalt on data validation list

EDIT No. 2 *Ok, my previous articulations of my problem were, as pointed out, pretty rubbish. This edit, rephrases the question in a more straightforward manner, summarises the context and provides ...
0
votes
1answer
146 views

How to populate a table with data from tables on other sheets using a drop down list

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I ...
0
votes
0answers
37 views

Navigating/clicking through hover dropdowns on a website

I'm trying to have my Excel VBA navigate to a particular page of a financial website but am not able to properly click through or select a drop down option on a "hover menu" to get to that page. I've ...
1
vote
0answers
115 views

Display value based from multiple dropdown list with IF, AND, SUMIFS

Attached below I show an example of what I'm trying to achieve Basically I want to have a result based on the chosen item from 2 dropdown list and a range of date. If you select "Name1" "Test 1" and ...
0
votes
0answers
13 views

Preventing duplicates in drop down content control in WORD

I have a word form that has a section with a table in it. In one of the columns of the table, I am using a drop down content control. Is there a way to prevent a user from selecting the same value ...
0
votes
0answers
29 views

How create a nested drop down in Excel? [duplicate]

Basically, the drop downs consists of: Region - Independent from Others Province - Drop Down that depends on Region with reference with Region ID Municipality - Drop Down that depends on ...
1
vote
0answers
77 views

Refresh drop down cell value in excel

I have a drop down cell which has a list of values. The problem is, I want to refresh the cell value to the 1st value of the list "JR" or other, whenever the I change the value on the "S235" cell. ...
0
votes
1answer
256 views

Bat to open webpage, choose from dropdown menu and automatically input proxy login

I'd like to run a bat that opens an specific webpage on Google Chrome, input proxy username and password right after launching the internet browser and pick an option from a dropdown menu. For the ...
0
votes
0answers
13 views

Pre-populating a result based on two different drop down menus

I'm creating a form that includes two drop-down menus. Each menu is independent of the other. What I need to do is create a formula that will populate information in another cell based on what's ...
0
votes
1answer
33 views

Excel dropdown with condition

I have searched for a while without being able to find a solution to my problem. A have a table named tbl_lov that contains the list of values used in a dropdown list via indirect function. INDIRECT("...
0
votes
1answer
336 views

Change dynamically a picture on a worksheet based on a value from a dropdown list

I use Windows 7 Professional and Excel 2013. I would like to change dynamically a picture on a worksheet based on a value from a dropdown list. I found online 2 ways that seems to fit my problem. ...
1
vote
1answer
21 views

“Link” two cells, modify one changes the other

I have a dataset that I use to generate some graphs. I have a cell in one sheet that changes my data based on the country I choose from a dropdown. I want to be able to change this dropdown from a ...
2
votes
0answers
88 views

Why are form field suggestions out of position in Chrome? [closed]

For a year or more I've had a problem with Chrome, always on the latest versions, where the suggestions dropdown is out of position. I've reset Chrome. I've disabled all extensions. Nothing resolves ...
1
vote
1answer
43 views

Next steps with accessing an Excel table from one sheet into another

I've done it once before, using a web tutorial that I cannot locate again, but now I'm trying to it again and I'd appreciate some insight in terms of “next steps” and where I am going wrong. I have ...

15 30 50 per page