Excel 2010 :: How To Insert Dropdown List With Checkbox Feature

Jul 29, 2014

I am looking to insert a drop down box in Excel 2010 which will allow users to select multiple items. At the moment I have data validation drop down lists in other columns, however I need one column to allow for multiple selections.

Basically I have a drop down which allows for a region to be selected, my next drop down (in the next column) I need to allow users to either select "ALL", or multiple countries which fall within the region selected previously. I need a check box so that users can select multiple countries, and deselect if an incorrect country is selected in error.

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Auto Complete With Dropdown List?

May 21, 2012

My Excel 2007 has "auto complete with a drop down list". When I type in the first character, a drop down list appears listing all the entries in that column tha start with that character. I click on one of the entries and the cell is "auto completed" with that entry. Sure is handy. I try to find that functionally in Excell at work, Office Professional 2010, and no bueno for kaki.

View 3 Replies View Related

Excel 2010 :: Dynamic Dropdown List Of Dates?

Aug 9, 2013

I'm trying to create a set of three dynamic/dependent drop down lists of date values, based on a set of imported data. Depending on whether the preferred choice is to list all dates in a range or just dates on the 15th, the available start and end drop down lists will change.

In addition, if possible I would then like to display a list of valid dates (not sure if this needs to be VBA).

The attached sheet shows/explains what I am attempting but here it is as well:

If B3 is set to show all dates in the month then:

the first dropdown option for C3 will be the first date of IMPORT (D2)
the first dropdown option for C4 will be the C3 value, to the last date in IMPORT (D) column

If B3 is set to show 15th of the month then:

the dropdown for C3 will be the first date of IMPORT (D) column with a date of 15th the dropdown for C4 will be in the range of C3 to the last date of IMPORT (D) column with a date of 15th only dates of 15th will be listed in both C3 and C4 dropdownlists

General

the dates in IMPORT column D are taken from IMPORT column A, B & C, which will be imported and will always be date sequential the number of rows of date entries will change with every import but there will never be any blank rows between dates the values in IMPORT columns A, B & C will always be numerical, and can be referenced if required [ideally] the LIST OF DATES will be populated with the date range, based on the option selected in B3

I'm fairly familiar with Excel (2010) and I have also done some VBA but I'm new to dynamic, nested dropdown lists and I'm unsure what the most practical way is to achieve this.

View 1 Replies View Related

Excel 2010 :: Populating Field From Dropdown List

Oct 24, 2011

I am using windows 7, excel 2010 I have a work book, my price list is sheet one and my list of customers and what discounts they get per item in sheet 2.

I choose customer on sheet 1, say i choose a & L sales, well on sheet 2 it shows they get a discount of 45 percent. so I want the 45 percent to show in cell 4r on sheet one, but if the dropdown box shows customer a & V it should show 35 percent because that is what it is on sheet two in cell 3c.

sheet two has 158 customers and each get a difference discount for that product

View 3 Replies View Related

Excel 2010 :: Getting Error When Try To Add Dependent Dropdown List

Oct 29, 2013

Creating a spreadsheet in Excel 2010 and am creating the dropdowns from a separate sheet in the workbook. There are no spaces and I don't know why I keep getting the "The Source currently evaluates to an error."

I am entering the Data Validation to reference the first cell I need "=INDIRECT(H3)"

I have put the spreadsheet on dropbox. When you select the "Sequencing Platform" drop down, it need to give just the dropdown for the platform selected.

[Code] ..........

View 2 Replies View Related

Excel 2010 :: Not Show Blanks In Dropdown List With AutoFilter?

Jul 21, 2014

How can I get the dropdown list to not include blank cells in the list reguardless if the sort filter is used or not.

Sheet 1 (STATS) is the dropdownlist Cell B12
Sheet 2 (Orders) is the data, I cant convert to tables because the cells are active and storted Column B2: is the data named.

so I have to use a formula to do this.

Using Excel 2010

See attached sample
Sample.xlsm

View 7 Replies View Related

Excel 2010 :: Keystroke To Select Variable Name From Dropdown List?

Jan 23, 2013

I've defined a number of variables in my spreadsheet. When I want to use one I type "=variablename" and 'm presented with a list menu.jpg

In the above example, I have several variables starting with the word "Harvard" (a town, not the university :-)

How do I select one of these without having to double click with the mouse.

Up and down arrows allow me to highlight an item but I cannot find a keystroke that allows me to select the highlighted item. Instead I have to lift my hand off the keyboard and use the mouse.

Excel 2010

View 2 Replies View Related

Excel 2010 :: Resetting Cell Values (Dropdown List)

Jun 23, 2014

I'm using Excel 2010. I have developed a calculator (attached) to make life easier for my colleagues. It works perfectly fine. But one thing keeps bugging me.

In Cell C3 - You have the option to choose "Daily" or "Weekly" (Drop Down). This selection effects your selection for Cell C6.

If you choose Daily in Cell C3 then your options for Cell C6 are restricted to select/enter an amount between £0.00 and £6.00.

If you choose Weekly in Cell C3 then your options for Cell C6 are restricted to select/enter either £0.00 or £12.00.

This works perfect.

However, if I select "Weekly" and then select " £12.00", all my results are perfect which is exactly what I want BUT if I then go back up to C3 and change "Weekly" to "Daily", the £12.00 in C6 remains (though the data validation for "Daily" is restricted to £0.00- £6.00) and all the results are consequently wrong until C6 is changed.

The obvious thing is to delete the £12.00 from Cell C6 or introduce a "clear" button BUT I don't want my colleagues to do this as it leaves the possibility of error and since we are dealing with money, I can't have it.

So what I would love and what would complete this calculator and deem it ready is if every time Cell C3 is selected (i.e. from the drop down list you choose Weekly or Daily) it as a result resets Cell C6 to £0.00.

Calculator 23-06-14.xlsx

View 6 Replies View Related

Excel 2010 :: Use Automatic Fill In Feature Of Formulas?

Oct 18, 2011

Still adjusting to 2010 Excel...How do you use the automatic fill in feature of formulas; e.g. when typing =convert....a fx function appears....not sure how to use it

View 2 Replies View Related

How To Create Dropdown Checkbox List On Each Row

Feb 11, 2014

I would like to know if there's a way to create a checkbox list in a cell that influences other cells:

For example, I would have column A as "Materials Accepted", and each cell would have a dropdown list with the options "Wood", "Drywall", and "Metal", in checkbox format. Then to the right of that, I would have each of the Materials as actual columns so that column B is "Wood", column C is "Drywall", and column D is "Metal".

The way I would want it to work from there is that whatever options I select from the dropdown, it would then put a TRUE flag in that column. So if I select "Wood" and "Metal" on the dropdown checkbox list, columns B and D would both read TRUE on that particular row.

Here is a screenshot of a mockup I did in paint - [URL]

Basically on each row, I would select a number of Materials, and the following columns for those Materials would populate TRUE for the ones that I selected on that row. This was just an example, but I would scale this up to around 30 Materials for hundreds of rows/entries.

View 1 Replies View Related

Excel 2010 :: Cell Insert In One Column To Insert In Other Columns?

Mar 23, 2012

I have a master data sheet with four columns, A, B, C and D

Column A has the primary data and B,C,D has dependent data values;

So when I insert a new cell in Column A with cells Shift Down, I want mandatorily new cells to be inserted in the same row in col B, C and D as well so that data integrity is maintained;

View 2 Replies View Related

Excel 2010 :: Change Font Size In A Checkbox?

Jan 30, 2013

How do you changethe font size in acheckbox in excel 2010?

View 1 Replies View Related

Excel 2010 :: Counting HTML Checkbox Values

Feb 1, 2013

I am copying a large table of data from a report generated in Firefox and pasting it into Excel 2010. The data has several columns of html checkboxes. I need to do two things with the checkboxes and would like to do a third:

1: Count how many checkboxes are ticked in each of the columns.
2: Compare a column A of checkboxes to a column B containing numbers, and then both count and highlight any row where the checkbox is ticked but column B is a 0.
3: (optional) I would like to erase the html checkboxes and, if the box was checked, replace it with a regular x in the underlying cell.

I found some code on another forum that generates a list of values for each checkbox (vba - Obtain the value of an HTML Checkbox inserted in Excel worksheet - Stack Overflow).

Based on that, I recorded a macro to extract the html Name of a single checkbox and then set up a Vlookup for the True/False value. However, I can't figure out how to automate a vlookup for every individual checkbox and put the data in the appropriate underlying cell.

View 3 Replies View Related

Excel 2010 :: VBA Code That Will Hide / Unhide A Row When Used With Checkbox

Jun 22, 2014

I need a VBA code that will when used with a Form Control "Check Box" will unhide / hide a row. To be more exact, I'm needind the code to "Hide" row 34 when unchecked and "Unhide" the same row when checked. I'm using Excel 2010.

View 9 Replies View Related

Insert A Dropdown List In Column

May 1, 2008

On my worksheet I am trying to insert a dropdown list in column B and the options available in this list are dependent on what is selected from another dropdown list in column A.

I have another spreadsheet in which I have done exactly the same thing. In this first sheet I use the methodology in column B of through Data Validation allowing a List and setting the Data Validation Source as =INDIRECT(L&A2) where L refers to my possible selection of lists for column B (these lists are called L1, L2, L3, L4 etc and have been defined as such). This then generates a list of options in the cell B2 dropdown list dependent on what the text is in A2. This A2 value has also been selected from a list.

Now when I tried to use exactly the same methodology in my new sheet IT DOES NOT work AARRGGHH !!! When I select a value from the list in column A, then go to the dropdown list in column B there are no options to choose from it is as if the dropdown filter in column B has become inactive. The selection downwards arrow is there, but when I click on it.

View 9 Replies View Related

Excel 2010 :: VBA To Change Form Control Checkbox Background Color When Checked

Nov 22, 2013

I have an Excel 2010 workbook with many worksheets using hundreds of Form Control (not ActiveX) checkboxes. I need a bit of VBA to change Checkbox background color of each checkbox whenever the user checks the box. I assume this needs to be a click event? I don't even know the Checkbox property name I need to change I'm learning VBA as quick as I can

View 4 Replies View Related

Excel 2010 :: Create Checkbox That When Ticked Shows Additional Area To Input Information?

Jan 10, 2014

I'm creating a basic form or templateusing Excel 2010 where the user will fill out information (See attached screenshot) I'd like to incorporate two a check boxes, that when ticked, change the display of the second table, either adding, removing or splitting of of the current columns in to two?

Is this, or any variation of, possible using Excel 2010.

View 2 Replies View Related

Excel 2007 :: Insert Dropdown Box Into Spreadsheet?

May 14, 2013

I need to insert a drop down box into my spreadsheet, and depending on the option selected, the formula used to calculate the value into another cell changes. How do I implement this in Excel 2007?

To put this in context, I need a list of acids in cell C3. Depending on the acid selected, the formula used to calculate acid concentration in another cell (D3) changes. I need a way to implement this.

View 3 Replies View Related

Excel 2011 :: Insert Calendar Dropdown For Mac

Dec 5, 2013

How to insert a Calendar Dropdown for Mac Excel 2011? Also, do I have to readjust this (for lack-of-a-better-word) 'add-in' everytime the calendar year changes? This will be used for a payroll template.

View 1 Replies View Related

Excel 2010 :: Dropdown Box And Formula?

Mar 14, 2012

I am using Excel 2010 .I have set up Data validation for a dropdown box so I can select from a list of items. In the old versions of Excel the actual drop down arrow used to appear in each cell. In the version I have, the drop down arrow only appears when you select the actual cell. When I did the validation I checked the " In-Cell Dropdown", but it still doesnt put the arrow in the cell. Is this functionality available in Excel 2010 ?

My second issue is a formula.

The last name is in a list of items and users have to select Yes or No to theitems on the list. I am wanting to create another spreadsheet that automatically populates based on their responses.

In short, I want to be able to set up a rule or formula that states if the answer in column A is "y" then I need the information in column B to be displayed.

The ultimate aim is to get a automatic sub set, (in another tab), of the orginal information based on users responses.

View 2 Replies View Related

Excel 2010 :: Inserting Dropdown Calendar

Jul 6, 2012

Using excel 2010, how do you insert a drop down calendar? Will this be able to display the date and then can I add a nuber to it and the result be a date

View 1 Replies View Related

Excel 2010 :: Conditional Formatting And Dropdown Box?

Jan 5, 2013

I'm running Windows XP with Excel 2010. I would like to be able to have a group of 19 boxes of which each box has a unique entry, ie 1, 3B, 5C etc. Each box I'd like to have a way in which when selected only the single or dual unique characters show as a color. See attached spreadsheet with sample. When a cell with lets say 1 is selected, a drop box appears and the color and description are shown. Select a color but only show the 1 and the color selected, leaving behind the description. How can I do this for all 19 boxes. This seems like its a classic conditional format. Unfortunately it appears to be several orders of difficulty than a normal conditional format.

View 2 Replies View Related

Excel 2010 :: Sorting / Filter Dropdown?

Mar 25, 2014

I'm trying to add a sorting filter dropdown on some columns in a sheet. If I select the column, then use Data -> Filter, it adds the filter. on that column. But then, if I select another column, the "Filter" button in the tool menu is already selected, even though there is no filter for that column. If I click it, the filter on the other column disappears. Then, clicking it again adds a filter for every single column. It seems I'm not able to select f.ex. 3 different columns and add a filter to only those. It's either all or none. Is this how it's supposed to work?

View 2 Replies View Related

Excel 2010 :: Dropdown Box To Hide Columns

Jan 31, 2012

I have seen in a number of spreadsheets that you can create a drop down list using data validation that hides certain columns depending on what you select. this leads me on to my question...

I have created a Gantt chart for an entire year and what to put a drop down box in C1 that contains four selections (Q1, Q2, Q3, Q4) to represent the four quarters of the year. I want to work it so that when the user selects Q1 it hides the columns where the other Quarters of the year are kept so you can only see that quarter.

If that is possible I would then like a second drop down box that allows the user to select a specific week.

Q1 is columns AW:DI.

I'm using excel 2010.

View 1 Replies View Related

Excel 2010 :: Dropdown Box Choice To Populate Next 2 Cells?

Jun 6, 2014

But for the life of me, I can't get it to do what I need it to do. Excel 2010 user, and I've attached my file with the information, and descriptions.

View 5 Replies View Related

Excel 2010 :: Hiding Rows Based On Dropdown

Mar 6, 2013

I am currently working on a workbook for work. It is a basic input output sheet. I have data from work that i copy and paste into sheet 1 and I have it arranged into sheet 2.

I am using windows 7 with Excel 2010, though needs to be compatible with 2007 using XP.

What I am trying to implement. I would have a drop down box in cell AD-4 with the current list

Select
Week 1
Week 2
Week 3
Week 4

What I want to implement is a code that if I select "week 1" from drop down then it will hide the entire row if data in column B = week 2, week 3, week 4, week 6

also

If week 2 is selected then hide entire row if column b = week 3 , week 4, week 5

so basically hide the weeks that are after the current selected week.

In addition to this I would also like to hide the entire row, regardless of drop down selection if data from J, K and O all = 0 or (blank).

(the first row is the current Row labels, I have a lot of current hidden columns).

A
B
J
K
O

Supervisor Name
Agent Name
Needs Complete
Completed w/o Turn in
Needs Turn In

[Code] ........

View 7 Replies View Related

Excel 2010 :: Add Search Box At The Top Like Traditional Dropdown AutoFilter?

Sep 4, 2013

I really like the slicers in Excel when working with data scenarios, but I don't like having to scroll up and down through the list of options.

Is there a way to add a "Search" box at the top like the traditional drop-down auto-filter? Or, does any loophole to making one?

View 2 Replies View Related

Excel 2010 :: Assign Macro To Value In Validation Dropdown Menu?

Feb 28, 2013

I have a validation drop down menu with the 12 months in it on Sheet 1. User picks the current month from the drop down list. I have 12 macros in the workbook, one for each month. Based on what month the user selects from the drop down, I would like to run a specific macro. The macro hides specific columns on sheet 2 of the workbook.

for example...user picks May from drop down which triggers macro MAY to run. If user picks Jun next month, macro JUN will run.

fyi...I'm using Excel 2010.

View 5 Replies View Related

Excel 2010 :: Insert Username Without VBA?

Apr 10, 2014

I'm keen to add a field to a spreadsheet that populates a cell with the username of the last person who edited the file, as in the system or logon name, e.g. first.lastname syntax.

I would however like to keep this sheet as an .xlsx and not have it as an .xlsm. I have the code to use VBA, but is there way to grab the username without VBA to keep the .xlsx format?

I'm using Excel 2010.

View 1 Replies View Related

Excel 2010 :: Dropdown Calendar To Work When Click In Any Cell In Specified Column

May 2, 2014

I am currently using a pop up calendar in Excel 2010 that with CTL+SHIFT+B that a calendar pops up, you select your date, and then the calendar closes. What I now need is to write a code or formula or something that when I click in any cell in column F lets say that the calendar opens automatically in that cell and then still close automatically after the date selection is made.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved