Its depend on how you are giving List values.. can you share you file..
"Value1,Value2" will give comma separated value as one element , "Value1","Value2" will give two element in dropdowns. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Srinivasaraghavan Sent: 27 July 2012 7:39 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Strange experience with Data validation Hi folks, I have been using Excel 2010 for a few months now. Not until recently i noticed something strange with Data validation. Thought i should check with the group if this is a known issue or something specific to my system. When i created Data validation with "Allow list"& input two drop down elements according to the syntax expected, it initally created both comma seperated drop down elements as one single element. So it showed up as True, False instead of True False It was only after considerable time that the drop downs appeared in the cell as it should. Any clues from anyone? Regards Rajesh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
