data validation list

  1. T

    Data Validation - Displaying two columns of results

    Hi All. I'd like to display two adjacent results from a long list of data by using data validation. My list has two columns which have the name of a racecourse in the UK and then the type of course, e.g "flat" or "jump". So if I have sample data in cells A1:B3 Col A Col B Aintree Jump...
  2. R

    VBA Input Box Data Restrictions

    Folks: My code in progress but is there a better way to force the user to input the correct month?: Sub INPUT_NUMBER_FROM_1_THRU_12() Dim myNum As Long myNum = Application.InputBox("Enter Month # from 1-12", "CURRENT MONTH") If myNum < 1 Or myNum > 12 Then myNum =...
  3. H

    How do I email a worksheet that uses names and Vlookup fields to just the selected individuals?

    I have a worksheet that in cell A2 has a list of names that is referenced though a data validation list on another sheet that has the data. The rest of the sheet uses Vlookup to reference the name selected to provide that persons information. There are some other static Vloookup information for...
  4. S

    Data Validation List

    Hello, I have a fairly large worksheet with many options. I am trying to create a tool to populate an answer based on multiple criteria which can be selected from 3 data validation lists. The first selection is the type of surface finish called "Commodities" (fabrics, paints...
  5. H

    Data Valdation Doesn't work when question marks (?) are entered

    Hello All, I'm experience an issue with cells in Excel 2010 which I have Data Validation turned on for, the user's are to enter "Yes" or "No" and receive an error message if they don't to try again. I was having a pilot user run through some QA Testing on the document, and they found if they...
  6. D

    Excel Macro to Create Independent Data Validation Lists

    I am writing a Macro in excel VBA that creates a data validation list in a specified cell. The program then prompts the user for the cells which contain the contents of the data validation lists. The same rows containing the list contents are then to be hidden from view. However, when I try...
  7. W

    Conditional Data Validation?

    Hi. Excel 2007 user on PC. I am trying to prevent contradicting answers in a form that asks a series of survey questions. In each cell where the person being surveyed can submit an answer, I use a data validation list with the answer choices. However, in some cases, depending on how an...
  8. H

    Forms - Prompts for a List using Data Validation

    I am creating a business form using excel 2007. I have fields that I would like to have a drop down list in. I would like for that field to have a prompt message that appears without having to click on the cell first. So that if you opened the sheet say cell B2 would say "Yes or No" and then...
  9. O

    Data Validation lists and Autocorrections

    Hey guys, I have some drop down lists that currently work as such Brand A allows you to pick from A1 A2 and A3 in the next cell, which in turn allows you to choose A1X, A1Y, and A1Z etc etc. however when I want to select a different brand, Brand B, the drop downs then look like Brand B, A1...
  10. 0

    Data Validation list with unique values (drop down menu)

    I have a column of numbers which contains numerous repeated entries and blank cells. The list is free to expand as people can continually add to the list. The list can only expand to a finite number of rows, say 150. Is it possible to use a bit of VB code to extract only unique entries and...
  11. H

    Allow multiple entries in Data validation

    Hi All Is there any way you can allow multiple entries to be selected and shown using data validation (or something else)? I have a spreadsheet which i have lifted off a list in sharepoint for some external users who do not have access to our network. The Sharepoint list allows the users to...
  12. B

    Data validation - pasted input won't auto-fill validation list item

    I am doing some conditional data validation and I have a huge chuck of data that I am pasting into the spreadsheet and I'm wondering if there is a way to make the pasted data auto-fill with the validated items? I have two columns with data validation (keyword, description) where description is...
  13. D

    Data Validation Bug in Excel 2010?

    Hello, I am having some issues testing an Excel 2003 template in Excel 2010. My main issue is with Data Validation lists. When I export an .XLT worksheet (saved in 97/2003 format) that contains a number of Data Validation lists and then open it in Excel 2010, some of my validation lists...
  14. B

    IF Then for multiple selections?

    I have several products in a list in cell C3, let's call them product A,B,C,D. When I select product A, I want D3 to show it's price and E3 to show wattage and F3 to show hours of life. Price, wattage and hours of life need to be associated to the specific product selected. How do I do this...
  15. J

    Open Ended Drop Down Lists

    Can I create a drop down list that will allow a user to either select one of the options provided in the list or create his own? As far as I can tell, using the data validation function does not allow a user to type something on this list. Thank you, Jim
  16. N

    Macro Not Running Across All Sheets

    I have a workbook that has 22 worksheets that are all formatted the same. Each has a data validation list in H3 and I am trying to set up a macro that will select one of the items in the list (in this case "Prior Week"). I would like to run the macro on all sheets. Below is the code I have...
  17. E

    using data validation selection in VBA code for a search

    I am using excel 2007 and Windows XP. I have created a data validation list; I would like to search a given range ie(B2:NXK2) for the value that I have selected from the data validation pull down menu. I have used this code to search for the value when I type in the value in an input box. I...
  18. L

    How to inactive cell

    Hi, How to inactive a cell for a certain value of another cell ? example : I have 2 cell with "data validation's list", let says: A1 contain list of : New, Used, Take Over A2 contain list of : Deposit, Credit Card, Other How can i inactive cell A2 if the value chosen in A1 is only "Take Over"...
  19. N

    How to create dependatn listboxes at runtime

    Hi. I have created a sheet that contains 3 listboxes. These are data validation lists that get created at runtime. It works well. But, I also have a column called "Associates" that is dependent on the "Customers" column. In other words, for each Customer, there are several Associates...
  20. N

    Can I have more than one list boxes on a Sheet?

    Hi there, I have created a data validation listbox on a sheet. This allows me to select an item on the list, and when I change the item, I put code on the "Worksheet_change" event to update the value of the item. Now, I need to add more listboxes to the same sheet. How can I make this possible?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top