I have created a drop down list but notice that the button (the arrow in the square) does not show up unless I click on the cell. Is there a way to show the button at all times so the user knows a drop down list is available?
View 9 RepliesI'm not sure this is even possible, but I have a long cell that has data validation. Right now, you have to move the mouse all the way over to click on the arrow to see the list. Is there a way (programmatically or otherwise) to make the down arrow show the list when you're in that cell??
View 10 Replies View RelatedI have a workbook with 7 sheets, the drop down list operates correctly on all but one sheet, it used to work on all sheets. The arrow on the right of the selected cell dose not appear onthis particulr sheet. I have rebooted the PC and double checked the in-cell option. I have search the forum for similar problem and found the same problem but no remedy.
View 2 Replies View RelatedI'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
View 2 Replies View RelatedI have a Workbook with a dropdownlist on it. The dropdown list has some names on it each name will be a refference to another sheet, ie when name Collins Jim is clicked on the drop down list the Jim Collins sheet will appear. I have attached a sample sheet to show you waht i mean.
View 4 Replies View RelatedIn excel when you have filters on for all columns there is a little bitty square box with a little down arrow (like an upside down triangle) in the lower right corner of every cell in the top row (the header row) and I can't find a way to select one of those little itty bitty down arrows without using a mouse - -
Is there any way to select one of those little down arrows in the little filter box icon thingy with the keyboard?? I can't figure it out.
I just want to select the little arrow so that the filter dialog box opens - I am trying to create a keyboard macro that will use the 'BEGINS WITH' macro but when i record the macro it uses the same word for the "BEGINS WITH" parameter every time and I want it to use the word in the current clipboard - can't seem to write that.
I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).
Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?
The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.
Can a macro be provided to show the list of sheet names in a drop down list at cell B2?
View 9 Replies View RelatedIm currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.
When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.
if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.
I have a spreadsheet with a number of columns regulated by Data Validation.
They are linked to lists with DV, which normally generates a nice drop-down box when you click on the cells.
I inserted a column into the spreadsheet, and now DV doesn't generate a drop-box anymore! In any of the columns! The "In-cell dropdown" box is still checked in my Data Validation screen, and the cells are still bound by validation to only conform to the lists.
Can anyone think of why these boxes would have disappeared? I've shut down Excel and re-opened the file in case it was a momentary glitch. I've deleted the inserted column... In short, I've tried everything I can think of.
Even if I remove Data Validation from the columns, and re-instate it with the "In-cell dropdown" box checked, I still don't get my drop-boxes.
I would be totally happy to send my complete file to anyone who wants it (although it's a bit big, as I have to send the directory structure if you don't want to get an error, about 1 MB), but anyhow - I'm reasonably desparate to get the drop-boxes back in.
I am currently working on a spread sheet that has a lot of data validation drop down lists. They were all working fine but now none of the drop down arrows are showing up.
View 3 Replies View RelatedI have set up a simple form in excel, whereby people use drop down menus to select the appropriate information (as all data inputted needs to be entered in exactly the same way to allow sorting, counting etc) so I thought drop downs were best. The trouble is the data is carried through to my excel database (on another worksheet) were it is shown in numeric values dependant on how far down the drop down list the select item appears (ie "Fareham" is third on the list, so shows in the database as "3").
I'd very much like my database to be easier to read and actually show Fareham etc, rather than be populated with lots of numbers. I initially tried using IF function (ie =IF(C3=3,"Fareham") but unfortunately two of my drop down lists are too long for this (with 25 and 33 entries respectively).
When using the autofilter, the drop-down arrow turns blue in color, i.e., when some filter citerion is being used, the small down-arrow turns a different color as a way of informing the user that a filter is in place. Is there a way to control the color of this? Currently, mine turns blue, but it would be more useful if I could change it to a brilliant color in order to make it contrast more with the default black. Blue is too difficult to be distinguished by my eyes. The autofilter is turned on via a macro. If there a line of code that controls the color.
View 2 Replies View RelatedI'm trying to create a formula where I can show the trend of two values from one month to the next that shows wheather the results went up or down in a positive or negetive value. For example:
If I have a transfer % of 18% in October and November MTD is at 17% - the arrow would then reflect downward showing in green, as the lower percentage is better. but I need the arrow to show upward in Red if say the value for November MTD was 19% instead.
I tried conditional formatting and attempted an "If" formula. I must not have all the information to create the formula as it errors out on me. I can create it if only looking to reflect one arrow...
=if(c3<b3,"")
I need a formula to tell me whether a number is a square number, or I can do it so to see if the square root of a number is an interger. So far Iv been doing
A1 = 2
A2 = AND(RIGHT(A1,1)=INT(A1))
True or false outcome is fine, and it has been working fine on some examples, but the problem comes when I have 49, as it is 2 digits long. I've seen a formula similar to find the root symbol, and look at all the numbers upto this point (maybe FIND).
I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .
View 4 Replies View RelatedI would like to be able to track progress of various tasks/occurences by allowing users of a spreadsheet to just click in the appropriate column and in doing so, it would fill in the current time and date. I.E. Column headings would read, "Item Sent to Review", "Item Received From Review", "Item Sent to Specialist", etc. and I want users to be able to double click in a given column to populate with current date/time information,
View 7 Replies View RelatedI currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.
View 4 Replies View RelatedI have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.
I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.
I can imagine that this is hard to picture so i have attached the file as well.
If I have a dropdown with
A (value 1)
B (value 2)
C (value 3)
D (value 4)
and a person selects one of those letters in the dropdown in column 1, I would like column 2 to show the number value associated with it
I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
I've created several dynamic range drop down lists and used DV procedure. They work fine, but when I drop down the list in a cell, the top item does not show. I have to scroll up to bring into view and select. How do I make the list show the top item.
View 5 Replies View RelatedI have a worksheet that is initially protected when a user views it. Certain cells are unlocked.
I have 46 drop down lists on the worksheet, of which none are locked so the users can access them for selections.
I want to unprotect the sheet when ANY of the dropdowns are clicked on.
For each change event I have the following
Sub DropDown34_Change()
Application.EnableEvents = False
ActiveSheet.Unprotect
However I still get the microsoft error screen showing up telling me that the cell is protected BEFORE it unprotects it and allows me to make changes.
In Excel 2007; I need my drop down list to then change the next cell down to a series of different values? How do i do this? i have created the drop down list, but can't link the values to the item selected in the drop down list. The JPG attached shows a basic set up of what i am trying to do: The drop down list contains various product models (yellow) Once selected this then changes the m2 value (red) which is linked to the formulas in orange; product factor is entered manually.
View 3 Replies View RelatedIs it possible to use a drop down list to populate cell elsewhere on the same worksheet?
View 9 Replies View RelatedI need to get the contents of a drop down list to a certain cell. I have figured out that if i highlite the drop down list and put "=A1" in the formula bar that it kinda works. But instead of putting the words in the cell, it puts how many rows down in the drop down box the item selected is.
View 9 Replies View RelatedI am wondering if it is possible to drag & drop, via left-click, the data in a cell but WITHOUT affecting it's reference -- i.e., like "Copy here as values only".
View 1 Replies View RelatedOne worksheet will have a library of job elements for assembly process with standard times on it.For example:Pick up a bolt(0.621m),install gasket(0.231m) etc.
The main worksheet will have a dropdown list which will list all the job elements discussed above.It will also have the quantity.So in otherwords,to pick up one bolt the time would be 0.621 minutes.But if anyone picks up 4 bolts the time would be 2.115 minutes,which can be calculated by the formula.So I want to display the job element,qty and the time in three separate rows.This worksheet will also calculate the total time for the assembly of the components which might contain more than thousand job elements.
My question is how do I ensure that picking up any of these job elements will give me the correct time.Is this something that can be done by formulas or anything thats built in excel or I need to run a macro or VBA to run some codes for IF...ELSE....THEN statements.There are too many conditions like If pick up one bolt time is 0.621 minutes,if pick up 4 bolts time is 2.115 minutes or if pick up a gasket time is 0.231 minutes.
I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.
View 4 Replies View Related