When you did in debug ?Target.Address, you saw it says $A$3 So I need to change it to If Target.address <> $A$2 Then Exit Sub But address is a string. Not sure if this is the correct forum but seeing as a macro was involved I thought I'd try here first! Or can this be solved. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... weblink
Some over look that because the arrow is over to right. Dim mainsrc As String Dim subsrc As String are they main source and sub source? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 3rd, 2011 #2 Tayt View Profile View Forum Posts I agreed to these rules Join Date 3rd March 2011 Posts Thanks.
All rights reserved. Register To Reply 01-26-2011,06:49 AM #7 royUK View Profile View Forum Posts Visit Homepage Forum Expert Join Date 11-18-2003 Location Derbyshire,UK MS-Off Ver Xp; 2007; 2010 Posts 26,205 Re: Drop down If you don't like Google AdSense in the posts, register or log in above.
Thanks, smalls Ask Your Own Question Excel Drop Down List Arrow Has Disappeared. - Excel Excel Forum I have created a drop down list in an Excel file. That should solve the problem. So, we might have 100 cells with data validation drop down lists, but you'll only see the arrow in the active cell. Excel Drop Down List Not Showing MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Edited by Martin van der Voort Monday, December 02, 2013 7:54 AM Monday, December 02, 2013 7:50 AM Reply | Quote 0
If you find the sheet to be protected, you can use this solution : http://mcgimpsey.com/excel/removepwords.html Hope it helps share|improve this answer answered Mar 27 '13 at 16:14 catalin775 111 Unable To View Drop Down List In Excel I originally created a workbook in 2007, got a new machine w/2010, saved the same wkbook (without touching the data validation) and now users w/2007 can't see the dropdowns!!! I've tried changing the macro setting in excel but this didn't work. What's the code What kind of drop down list?
TX G See more Dropdown lists in excel 2007 Excel 2007 Dropdown list from multiple column Excel - Run macro when item is selected from dropdown list Adding a new entry I was having the same problem and came up with a workaround. Excel 2010 Drop Down List Not Working If this is your original dropdown box formula: =Sheet2!A1:A5 Then change it to: =INDIRECT("Sheet2!A1:A5") For me, this stops it removing the dropdown when opening in Excel 2007 after saving in Excel Excel Drop Down Boxes Not Working I have no idea whether it is a known issue cause I cannot reproduce this behavior in my Excel 2013/2007.
If you find the sheet to be protected, you can use this solution : http://mcgimpsey.com/excel/removepwords.html Hope it helps share|improve this answer answered Mar 27 '13 at 16:12 catalin775 1 add a http://sevevb.com/drop-down/drop-down-list-not-working-in-excel-2007.html I thought it might be that Excel 2007 doesn't like the drop downs being on one tab but then why do some drop downs on some tabs work but others don't? I have two spreadsheets. I found out that Data validation (including macro's) that work in 2010, don't work in 2007. Excel Drop Down List Disappeared
Can anybody advise what type of connector this is? Ask Your Own Question Creating Drop Down List - Excel Excel Forum I was looking to create a drop down list. This will change the position of ... check over here If it requires visual basic, my knowledge is Zero, so I would need very basic steps to take me through this!
Will I get a visa again? Drop Down List Works In Excel 2010 But Not 2007 Thanks. Looking forward to hearing you.
MathSciNet review alert? We need your input to help create a new Live Online Excel Help service. When you're finished, the Subject column should look like this: And the Grade column should look like this: In the next part, you'll see how to add an error message Excel 2007 Drop Down List From Another Sheet I tried naming my list and using source =myRangeList where myRangeList is the name of the list.
Is this possible? Highlight Duplicate Values in Excel How to highlight duplicate values in a list. How do I handle this? this content In Source box write =MyMainList 15.
it was because I had entered values in other cells in the same row as the validation... It is just a variable. Ask Your Own Question Disable/enable Combo Box (drop Down List) - Excel Excel Forum After running a macro, I need to disable a combo-box (drop down list). The CELLS is a range.
i've opened a new thread named validation lists in VBA... Microsoft,this should be a standard option! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 23rd, 2015,02:40 AM #4 leanneypants New Member Join Date May 2013 Posts 5 Re: drop down list missing