data validation list

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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"...

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...

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?

Hi everybody, I have a sheet containing (among other things) a list of personal IDs in one row, and dates in another row. This list may contain more than one occurence of the same ID, but with different dates. In another sheet, I want to be able to do like this: 1. In cell A1, enter a...