drop-down

Here is a gross over-simplification of my dataset in Excel (it's larger and more purposeful than this). It's in a table, at this point with quite a few more columns and vastly more rows. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

Hello, I would like to have a drop-down list in A1. Based on the value selected in the drop-down list in A1, I would like a specific parage of text to pop up in A2. I would like for this text in A2 to be editable so minor things can be changed as needed. Is this possible?

Re: Restrict entry on certain cells based on multiple drop drop-down list******** id="google_ads_iframe_/22152718/MrExcel_InContent_0" title="3rd party ad content" name="google_ads_iframe_/22152718/MrExcel_InContent_0" width="300" height="250" scrolling="no" marginwidth="0" marginheight="0"...

Hey folks, Having an issue with our Excel data collection and hoping for help. I run data collection for national survey we are conducting for our organization. For years we have used an Excel spreadsheet to catalog the demographic information of our members and have used drop down boxes for...

Hi, Would there be a way to link a dropdown list value to a user form? The appointment column "D" has drop-down list. The drop-down list values are: Confirmed Rescheduled Cancelled If a user selects, "Rescheduled", a pop up form should appear to users to select the following checkboxes...

Hello, I m at a form, and there is a drop-down list. When clicking on a drop-down list it searches and results from the names of the cells. I did this formula because I had seen that Excel for Mac does not recognize the UsedRange.Rows command. Dim oneCell As Range For Each oneCell In...

Morning all, Im putting together a process which includes lots of screen shots but when I try to capture a filter in drop-down it disappears before I can capture the image. Is there a way of doing this? Thanks in advance. Stuart

Hi. I want to link a macro to a Drop-down to Hide 4 columns to the right of the column the drop-down is found and then to Unhide again. It will act like a toggle button rather than using a button I want to use a drop-down and assign the macro to the relevant source heading. The two source...

I very much like this link: Populate userform combobox with unique values from a range It explains how to get a drop down list of unique values and that is exactly what I need but I have almost 7000 options. I want the user to be able to start typing the value and have the drop-down populate...

Hi. I am creating a spreadsheet for product attributes, which will ultimately be used for generating product SKUs. On one sheet of same workbook I created lists for size, color, material, etc. and applied Define Name. On another sheet (same workbook) I created a drop-down list using Data...

Hi, I have a sheet where I have several drop-down menus. I would like to know if I can get a VBA code that shifts the active cell as soon as a value have been chosen in a drop-down menu. Example: Lets say that cell A1 has a drop-down menu containing "YES" and "NO". Depending on my choice...

I have a sheet where the user makes a selection from a drop-down menu. A cell (where I currently have a VLOOKUP), then auto-populates with a rate based on what they selected in the drop-down. All works fine and good, but here's where my question comes in. The rate that is autopopulated is a...

I have a drop-down list in both cells A1 and A2 each with different values. I am trying to let a vlookup override the drop-down list in A2. For example when you select 'Leave' in A1, A2 must automatically choose a specific value from the drop-down list in A2 that cannot be changed. I tried a...

Is there any method in which using a combination of VBA and data validation in Excel I'd be able to select values from a drop-down menu and have it add this text back to the cell value in a: text/text/text/text format? I have a cell (current row of column R) in which I keep track of the types...

i'd like a simple "status" drop-down menu to appear in the selected cell. the options are pre-defined: "Not started" (appears by default) "Work in progress" "Finished" "Not applicable" I would like to define a name for the cells containing the status, so i don't know if a commobox can work...

Hello. Very basic excel user. I've tried researching the answer to this with no luck. Was hoping someone can perhaps shed some light. I have 2 columns. Column D10:D100 consist of drop-down text. For example, Apple, Banana, Cherry, Dingo, Eat, Fun. B1:B10 Consists of this same list. What I need...

Dear all, I am working on a global email communications report covering 12 markets. As per the screenshot attached, I would like to filter results based on the cell value in D3 ("Austria") whereas D3 is a drop-down listing all 12 markets in two variants (one is just the market e.g. "Austria"...

Hi I've created a number of conditional drop-down lists in a userform. Where the section made in one field will affect the list that's returned in another. Now most of the lists are working fine but there's just this one that is unrelenting and refusing to work. When you click on the drop-down...

So I have a Sheet, where I want to show only the data which is relevant based on the user's selection in the drop-down list (G3). My code so-far: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G3")) Is Nothing Then Application.Run "HideRows" End If End Sub...

I've searched high and low and can't seem to find anything that works and I'm hoping that one of you will take pity on me and help me out. :) What I'm trying to do: User selects a value from a drop-down list This value determines references which named list of headers on another page should...